Getting error during importing [message #293409] |
Sat, 12 January 2008 05:36 |
jitender.sadh
Messages: 86 Registered: May 2007
|
Member |
|
|
hi
i import the ".dmp" file sucessfully but during the importing process i am getting error messages.i am sending the scree shots of the error message, with my message.after import when i count total number of triggers,constraints ,indexes ,tables ,i found that the number of tables is same but i lost some of the triggers ,constraints ,indexes to create.
regards
jitender.
-
Attachment: untitled1.bmp
(Size: 804.06KB, Downloaded 1017 times)
|
|
|
|
|
|
|
|
|
|
|
Re: getting error during importing [message #293847 is a reply to message #293846] |
Tue, 15 January 2008 04:45 |
jitender.sadh
Messages: 86 Registered: May 2007
|
Member |
|
|
hi
i parovide maxsize unlimited , during tablespace creation.
SQL> CREATE TABLESPACE NDS DATAFILE 'D:\DATAFILES\NDS.DMP' SIZE 4600M
2 AUTOEXTEND ON NEXT 450M
3 MAXSIZE UNLIMITED
4 extent management local;
Tablespace created.
regards
jitender.
|
|
|
|
Re: getting error during importing [message #294016 is a reply to message #293849] |
Wed, 16 January 2008 00:56 |
jitender.sadh
Messages: 86 Registered: May 2007
|
Member |
|
|
hi
i increased the size of tablespace INDX and the number of tables,constarints,index are same but still i am getting error during trigger export.
. . importing table "FAC_VCH_D_PROV_BACK" 0 rows imported
. . importing table "FAC_VCH_D_PROV_MLP_200106" 0 rows imported
. . importing table "FAC_VCH_D_PRV_TEMP" 0 rows imported
. . importing table "FAC_VCH_D_TDS" 0 rows imported
. . importing table "FAC_VCH_EXP" 1558 rows imported
. . importing table "FAC_VCH_EXP_P" 0 rows imported
. . importing table "FAC_VCH_EXP_TDS" 0 rows imported
. . importing table "FAC_VCH_FRGTSC" 0 rows imported
. . importing table "FAC_VCH_LTCEXP" 0 rows imported
------------------------------------------------------------------------------------
. . importing table "FAC_VCH_M" 19594 rows imported
------------------------------------------------------------------------------------
. . importing table "FAC_VCH_MPRV_TEMP" 0 rows imported
. . importing table "FAC_VCH_M_PROV" 1 rows imported
. . importing table "FAC_VCH_M_PROV_MLP" 0 rows imported
. . importing table "FAC_VCH_SCRPSL" 0 rows imported
. . importing table "FAC_VCH_TELEXP" 0 rows imported
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "NDS"."AFETR_INSERT" AFTER INSERT ON NEWTON.FAC_VCH_M REFERE"
"NCING NEW AS NEW OLD AS OLD FOR EACH ROW "
"DECLARE"
" TEMP_DIV_CODE VARCHAR2(6);"
" TEMP_VC_NUM VARCHAR2(7);"
" TEMP_VC_TP VARCHAR2(4);"
regards
jitender.
|
|
|
|