DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Export Problem

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi

    When I try to export, I am getting the following error, can you help me in this issue?


    Export: Release 8.1.7.0.0 - Production on Fri Feb 15 14:51:39 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production
    Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
    server uses UTF8 character set (possible charset conversion)

    About to export specified tables via Conventional Path ...
    . . exporting table MST_USER
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    EXP-00008: ORACLE error 6550 encountered
    ORA-06550: line 1, column 29:
    PLS-00302: component 'IS_TRIGGER_FIRE_ONCE_INTERNAL' must be declared
    ORA-06550: line 1, column 8:
    PL/SQL: Statement ignored
    EXP-00056: ORACLE error 1403 encountered
    ORA-01403: no data found
    EXP-00000: Export terminated unsuccessfully

    Thanks In Advance

    Nagesh

  2. #2
    Join Date
    Oct 2001
    Posts
    45
    Hi gnagesh,
    It's obvious your export version(8.1.7) is higher than database version (8.1.6). This is the reason you got errors. You can use export of the same or lower version as db version.

    Regards.
    Xiao Mao


  3. #3
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323

    Question

    Correct.

    Is there any work around to get out of this kind of problems?
    Nagesh

  4. #4
    Join Date
    Oct 2001
    Posts
    45
    Refer to doc. Note:132904.1.

  5. #5
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Thank You
    Nagesh

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