-
Export error EXP-00079
Hi,
My oracle 9i database is running in WINNT. When i export i got the error
EXP-00079: Data in table "WK$ATTRIBUTE" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$ATTRIBUTE 0 rows exported
EXP-00079: Data in table "WK$ATTR_MAPPING" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$ATTR_MAPPING 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table WK$CHARSET 57 rows exported
EXP-00079: Data in table "WK$CRAWLER_CONFIG" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$CRAWLER_CONFIG 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table WK$CRAWLER_CONFIG_DEFAULT 33 rows exported
EXP-00079: Data in table "WK$CRAWLER_SCHED" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$CRAWLER_SCHED 0 rows exported
EXP-00079: Data in table "WK$CRAWLER_STAT" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$CRAWLER_STAT 0 rows exported
EXP-00079: Data in table "WK$DATA_SOURCE" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$DATA_SOURCE 0 rows exported
EXP-00079: Data in table "WK$GROUP_DS_MAPPING" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$GROUP_DS_MAPPING 0 rows exported
. . exporting table WK$INSTANCE 0 rows exported
. . exporting table WK$INST_ADMIN 0 rows exported
EXP-00079: Data in table "WK$JOB_INFO" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$JOB_INFO 0 rows exported
. . exporting table WK$LANG 10 rows exported
EXP-00079: Data in table "WK$MAILLIST" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$MAILLIST 0 rows exported
. . exporting table WK$MIMETYPES 35 rows exported
EXP-00079: Data in table "WK$SCHED_MAPPING" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$SCHED_MAPPING 0 rows exported
EXP-00079: Data in table "WK$SOURCE_GROUP" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$SOURCE_GROUP 0 rows exported
EXP-00079: Data in table "WK$SYSINFO" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$SYSINFO 0 rows exported
EXP-00079: Data in table "WK$SYS_ADMIN" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$SYS_ADMIN 0 rows exported
EXP-00079: Data in table "WK$TDS_LOG" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$TDS_LOG 0 rows exported
EXP-00079: Data in table "WK$TRACE" is protected. Conventional path may only be exporting partial table.
. . exporting table WK$TRACE 0 rows exported
How to fix this!!!!
Many Thanks,
-
In many cases the Oracle Error Messages guide is not very helpful if providing a solution to problems. This isn't one of those cases though -- if you'd bothered to look up the error message you'd have found a very adequate explanation, and suggestions for fixing the problem.
Long story short -- RTFM.
-
Can u post the export backup par file script.
-
Hi,
exp admin/pss file=export.dmp log=export.log full=y compress=y
Many Thanks,
-
Is "Fine Grained Access Control" being used? If yes export as sys to bypass FGAC.
HTH