C:\>dir c:\test1.dmp
 Volume in drive C has no label.
 Volume Serial Number is CC55-E5A1

 Directory of c:\

05-12-2006  08:54 PM         5,355,520 test1.dmp
               1 File(s)      5,355,520 bytes
              0 Dir(s)   5,992,534,016 bytes free

C:\>imp hr/hr full=y file=c:\test1.dmp

Import: Release 10.1.0.2.0 - Production on Mon Dec 11 17:13:03 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.01.00 via conventional path

Warning: the objects were exported by SYSTEM, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing SYSTEM's objects into HR
. . importing table                         "TAB1"      49294 rows imported
Import terminated successfully without warnings.

C:\>sqlplus "hr/hr"

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Dec 11 17:13:12 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select created,last_ddl_time
  2  from user_objects
  3  where object_name = 'TAB1';

CREATED   LAST_DDL_
--------- ---------
11-DEC-06 11-DEC-06

SQL>