Export and Import of Oracle database tables .......

Export of Oracle database tables:

 

Step 1: C: \ Documents ents and Settings \ Administrator> exp

Export: Release 10.2.0.1.0-production on Thursday August 30 14:06:18 2012

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Step 2: Username: fwzcgl/fwzcgl @ oradb222

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options
Buffer size for input array extraction: 4096>

Step 3: export the file: expdat. DMP> C: \ 2012.dmp

(1) E (complete database), (2) U (User) or (3) T (table): (2) U>

Export Permission (yes/no): Yes>

Export table data (yes/no): Yes>

Compression zone (yes/no): Yes>

The zhs16gbk and al16utf16 nchar character sets have been exported.

Will export the specified user...
Fourth: users to be exported: (exit by return)> fwzcgl

User to be exported: (exit by return)>