• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
We have a problem using the Data Pump in Aleph 19/Oracle 10.

Can I use the Oracle "exp" command to export data?

Resolution:
The following is a dialog, using the "exp" command, of an export of the abc50 z104 table....

aleph.abc.edu-19(2)>>dlib abc50
aleph.abc.edu-19(2)>>df1
aleph.abc.edu-19(2) ABC50-ALEPH>>exp

Export: Release 10.2.0.4.0 - Production on Wed Nov 17 14:55:28 2010

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


Username: ABC50
Password: ABC50

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > abc50.z104.expdat.dmp

(2)U(sers), or (3)T(ables): (2)U > tables(ABC50.Z104)

Export table data (yes/no): yes > yes

Compress extents (yes/no): yes > yes

Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified tables via Conventional Path ...

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

. . exporting table Z104 35 rows exported

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

Export terminated successfully with warnings.
aleph.abc.edu-19(2) ABC50-ALEPH>>ls -lrt *dat*
-rw-rw-r-- 1 aleph aleph 7168 Nov 17 14:57 abc50.z104.expdat.dmp
aleph.abc.edu-19(2) ABC50-ALEPH>>

• Article last edited: 10/8/2013