1753280 Members
5436 Online
108792 Solutions
New Discussion юеВ

error export

 
dngaya
Advisor

error export

hi,
i have oracle datadase release 7.3.4 install in hp 10. this database is my datawarehouse. when the export is started at night, there is errors in some tables. here the extract of the file of error :

EXP-00036: Object 13089 non-existent in dictionary
. . exporting table CI_DSTRBTR_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_DSTRBTR_LGHT
. . exporting table CI_DSTRBTR_LGHT_SAV 13395 rows exported
. . exporting table CI_DSTRBTR_SITU 386 rows exported
EXP-00036: Object 13081 non-existent in dictionary
. . exporting table CI_FUND_GLOB_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_FUND_GLOB_LGHT
. . exporting table CI_FUND_GLOB_LGHT_SAV 186401 rows exported
EXP-00036: Object 13083 non-existent in dictionary
. . exporting table CI_FUND_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_FUND_LGHT
. . exporting table CI_FUND_LGHT_SAV 48293 rows exported
. . exporting table CI_LIEN_CNTRCT_PERF 25197 rows exported
. . exporting table CI_OPE_LGHT 1393278 rows exported
. . exporting table CI_PERF_EUR_SITU 35 rows exported
. . exporting table CI_PERF_UC_SITU 708 rows exported
EXP-00036: Object 13082 non-existent in dictionary
. . exporting table CI_PROD_GLOB_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_PROD_GLOB_LGHT
. . exporting table CI_PROD_GLOB_LGHT_SAV 41757 rows exported
EXP-00036: Object 13084 non-existent in dictionary
. . exporting table CI_PROD_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_PROD_LGHT
. . exporting table CI_PROD_LGHT_SAV 3416 rows exported
EXP-00036: Object 13087 non-existent in dictionary
. . exporting table CI_RSRC_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_RSRC_LGHT
. . exporting table CI_RSRC_LGHT_SAV 48457 rows exported
EXP-00036: Object 13088 non-existent in dictionary
. . exporting table CI_RSRC_OBJ_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_RSRC_OBJ_LGHT
. . exporting table CI_RSRC_OBJ_LGHT_SAV 131976 rows exported
EXP-00036: Object 13085 non-existent in dictionary
. . exporting table CI_SBSCRPT_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_SBSCRPT_LGHT
. . exporting table CI_SBSCRPT_LGHT_SAV 24005 rows exported
EXP-00036: Object 13086 non-existent in dictionary
. . exporting table CI_SUB_RSRC_LGHT
EXP-00007: dictionary shows no columns for AVIP.CI_SUB_RSRC_LGHT

please, another can help me for to resolve this problem.
thank you for your help.
3 REPLIES 3
Hari Kumar
Trusted Contributor

Re: error export

1.The Object mey be dropped during the course of export.
2.If you have not applied with 7.3.4.4 or above patch set, then please do go with Oracle support services for Internal error or the patch set upgaradtion.Its a bug with 7.3.3[BUG:724499].

HTH
Information is Wealth ; Knowledge is Power
Hari Kumar
Trusted Contributor

Re: error export

You can check by selecting the above tables present in the database or, if not then the Error message is a warning and nothing to do, only by doing export when NO user operations.

If the tables exist, then go for Oracle internal support, fix the Patch with 7.3.4 by upgrading it to 7.3.4.4 or above...........

Thanks,
Information is Wealth ; Knowledge is Power
Yogeeraj_1
Honored Contributor

Re: error export

hi,
*
This bug is documented in metalink Note:100979.1. see attached the extract.
*
Consider upgrading to patchset 7.3.4.4 or above when convenient.
*
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)