Export and Import

C:\>exp

 

Export: Release 9.2.0.1.0 - Production on Thu Jan 29 23:58:01 2009

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

Username: scott

Password:

 

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

Enter array fetch buffer size: 4096 >

 

Export file: EXPDAT.DMP > test

 

(2)U(sers), or (3)T(ables): (2)U > 3

 

Export table data (yes/no): yes >

 

Compress extents (yes/no): yes >

 

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

 

About to export specified tables via Conventional Path ...

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > emp

 

. . exporting table                            EMP         14 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) >

 

Export terminated successfully without warnings.

 

SQL> create table emp1 as select * from emp;

Table created.

 

SQL> drop table emp;

Table dropped.

 

C:\>imp

Import: Release 9.2.0.1.0 - Production on Fri Jan 30 00:02:51 2009

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

Username: scott

Password:

 

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

 

Import file: EXPDAT.DMP > test.dmp

 

Enter insert buffer size (minimum is 8192) 30720>

 

Export file created by EXPORT:V09.02.00 via conventional path

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

List contents of import file only (yes/no): no >

 

Ignore create error due to object existence (yes/no): no >

 

Import grants (yes/no): yes >

 

Import table data (yes/no): yes >

 

Import entire export file (yes/no): no > y

 

. importing SCOTT's objects into SCOTT

. . importing table                          "EMP"         14 rows imported

About to enable constraints...

Import terminated successfully without warnings.

Comments