Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Question Unanswered: error export database

    Hi,
    when I export the Oracle database I always get this error message at the end :

    . exporting referential integrity constraints
    . exporting synonyms
    . exporting views
    EXP-00008: ORACLE error 604 encountered
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01422: exact fetch returns more than requested number of rows
    ORA-06512: at line 8
    ORA-01436: CONNECT BY loop in user data
    EXP-00000: Export terminated unsuccessfully


    I use Oracle 8.1.5.0.2 running on Novell Netware 5.1 sp6


    I do a full export with a .ncf (like a .bat) command :
    load exp81 system/xxx parfile=oracle1:\oranw815\nlm\export.par

    The export.par file is :
    buffer = 30000
    file = oracle1:dmp\export.dmp
    log = oracle1:dmp\export.log
    full = y
    consistent = y


    Can someone help me?
    thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    It seems that you have one or more corrupted blocks. Try to run dbv against your file(s) and fix it. I guess it will help you out.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    Export generates the list of objects to be exported at the beginning of the export for each user. If a table is dropped after this time, export will report an error like you encountered. These look like, perhaps, temporary tables. Does your application create temporary tables? Do you know what these tables are/were?
    SATHISH .

  4. #4
    Join Date
    Nov 2003
    Posts
    4
    Originally posted by Hings
    It seems that you have one or more corrupted blocks. Try to run dbv against your file(s) and fix it. I guess it will help you out.
    Thanks, I'll try this.

  5. #5
    Join Date
    Nov 2003
    Posts
    4
    Originally posted by satish_ct
    Hi,

    Export generates the list of objects to be exported at the beginning of the export for each user. If a table is dropped after this time, export will report an error like you encountered. These look like, perhaps, temporary tables. Does your application create temporary tables? Do you know what these tables are/were?
    No, my applications doesn't generate any temporary tables and no tables are dropped before, during or after the export.
    The export is done after the work hours when there is nobody working on the database.

  6. #6
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    Run catexp.sql and see if this resolves the problem.

    This sometimes occurs if the export version is more recent than the database version . Make sure to use version of export.
    SATHISH .

Posting Permissions

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