This discussion is archived
4 Replies Latest reply: Dec 5, 2002 8:28 AM by 150097 RSS

FULL EXPORT PROBLEM

317864 Newbie
Currently Being Moderated
I am running Oracle 8.1.7.3.0 and applying two patches of Oracle Spatial already and I still have problem with the full export or user export, below is the errors:

. 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 A. Index creation will be skipped
EXP-00008: ORACLE error 0 encountered
ORA-00000: normal, successful completion
EXP-00078: Error exporting metadata for index B. Index creation will be skipped
EXP-00008: ORACLE error 0 encountered
ORA-00000: normal, successful completion
EXP-00078: Error exporting metadata for index C. Index creation will be skipped
EXP-00008: ORACLE error 0 encountered
ORA-00000: normal, successful completion
EXP-00078: Error exporting metadata for index D. Index creation will be skipped
EXP-00008: ORACLE error 0 encountered
ORA-00000: normal, successful completion
EXP-00078: Error exporting metadata for index E. Index creation will be skipped
EXP-00008: ORACLE error 0 encountered
ORA-00000: normal, successful completion
EXP-00078: Error exporting metadata for index F. Index creation will be skipped
EXP-00008: ORACLE error 0 encountered
ORA-00000: normal, successful completion
EXP-00078: Error exporting metadata for index G. Index creation will be skipped
EXP-00008: ORACLE error 0 encountered
ORA-00000: normal, successful completion
EXP-00078: Error exporting metadata for index H. 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.


any adives what to look for or how to fix this problem???

  • 1. re:FULL EXPORT PROBLEM
    91061 Newbie
    Currently Being Moderated
    Hi,

    Is there an entry in user_sdo_geom_metadata for the tables that the metadata isn't exported for?

    Also, did you apply the generic patch?
    ID:1489133 Patchset::2247361 GENERIC SPATIAL PATCHSET 2 FOR ORACLE 8.1.7.3

    Dan
  • 2. re:FULL EXPORT PROBLEM
    150097 Newbie
    Currently Being Moderated
    Hi,
    Is there an entry in user_sdo_geom_metadata for the tables that the metadata isn't exported for?
    can you elaborate your question again please???? when I look into the USER_SDO_GEOM_METADATA view, the metadata for those indexes that had problem was there.
    Also, did you apply the generic patch?
    ID:1489133 Patchset::2247361 GENERIC SPATIAL PATCHSET 2 FOR ORACLE 8.1.7.3
    Yes, I have this patch applied along with the first patchset for Oracle SPatial
  • 3. re:FULL EXPORT PROBLEM
    150097 Newbie
    Currently Being Moderated
    John,

    I have simliar problem before.

    what you need to do is applied patch 2228622 and the other patch as Dan mention, look at the metadata in SDO_GEOM_MATADATA_TABLE to see if it's there
  • 4. re:FULL EXPORT PROBLEM
    150097 Newbie
    Currently Being Moderated
    I forgot to mention one thing, have you tried to drop index and recreate the indexes??? It could be that those indexes are corrupted