Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Using the Oracle "exp" command to export data

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

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

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

    The following is a dialog, using the "exp" command, of an export of the abc50 z104 table....>>dlib abc50>>df1 ABC50-ALEPH>>exp

    Export: Release - 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 - 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. ABC50-ALEPH>>ls -lrt *dat*
    -rw-rw-r-- 1 aleph aleph 7168 Nov 17 14:57 abc50.z104.expdat.dmp ABC50-ALEPH>>

    • Article last edited: 10/8/2013