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

Thread: export errors

  1. #1
    Join Date
    Aug 2001
    I have this errors on my export.

    . exporting referential integrity constraints
    . exporting synonyms
    . exporting views
    . exporting stored procedures
    . exporting operators
    . exporting indextypes
    . exporting bitmap, functional and extensible indexes
    EXP-00008: ORACLE error 0 encountered
    ORA-00000: normal, successful completion
    EXP-00078: Error exporting metadata for index QTREE. Index creation will be skipped
    . exporting posttables actions
    . exporting triggers
    . exporting snapshots
    . exporting snapshot logs
    . exporting job queues
    . exporting refresh groups and children
    . exporting dimensions
    . exporting post-schema procedural objects and actions
    . exporting user history table
    . exporting default and system auditing options
    . exporting statistics
    Export terminated successfully with warnings.

    basically from metalink it said that I have someone owned the index and that index in the table owned by somoene else.
    The problem I have is how do I know which index ??? How to find out ???

    Please advise

  2. #2
    Join Date
    Jan 2001
    SQL> select owner, index_name, table_name, table_owner
    from dba_indexes
    where index_name='QTREE';

    Is this what you are looking for?
    I remember when this place was cool.

  3. #3
    Join Date
    Aug 2001
    That's not what I am looking for. that's query only give me all of the indexes which are QTREE.

    Any way, I just want to figure it out how to get a good dump file so I can rebuild my database.

    please advise , it's very urgent!!!!!!

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