error in exporting partition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: error in exporting partition

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    82
    Hi guys,
    Do you have any idea why I received this message from my export? Does that mean the export was complete or what? Is the export good?

    Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production
    Export done in US7ASCII character set and US7ASCII NCHAR character set

    About to export specified tables via Conventional Path ...
    . . exporting table SAN
    . . exporting partition SAN_AUG2000
    EXP-00008: ORACLE error 0 encountered
    ORA-00000: normal, successful completion
    Export terminated successfully with warnings.

    Version: 8i(8.1.5.0.0)
    O/S: AIX


    Below is my parfile:
    userid=*****/*********
    buffer=101000060
    file=/oradata/part_san_aug2000.dmp,
    log=partforsanaug_2000.log
    tables=(san:san_aug2000)
    consistent=y
    query='where ename is not null'''

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Strange error. Based on the description of the error, the partition was successfully exported and the export is good. Verify logfile for any other errors.

  3. #3
    Join Date
    Mar 2001
    Posts
    82
    Thanks for the reply. I checked from the log file and below are its contents:

    Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production
    Export done in US7ASCII character set and US7ASCII NCHAR character set

    About to export specified tables via Conventional Path ...
    . . exporting table SAN
    . . exporting partition SAN_AUG2000
    EXP-00008: ORACLE error 0 encountered
    ORA-00000: normal, successful completion
    Export terminated successfully with warnings.


    Any more thoughts?

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    None. Everything should be ok. I checked on Metalink for this error, and it is said that this error should be considered as a 'NULL' error and can be disregarded.

  5. #5
    Join Date
    Mar 2001
    Posts
    82
    Thanks Halo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width