Export and Import

C:\>exp

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

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

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.