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

    Using the Oracle "exp" command to export data

    • 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