-
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
-
SQL> select owner, index_name, table_name, table_owner
from dba_indexes
where index_name='QTREE';
Is this what you are looking for?
MH
I remember when this place was cool.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|