OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import Problem [message #134008]

Tue, 23 August 2005 04:39

balasmg
Messages: 31
Registered: June 2005
Location: bangalore

Member

Hi,

While importing the datas from production to test user .
The datas imported and in log file I found these errors.

It seems to be problem with triggers.
Pl. let us know what may be problem and how do solve this

IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADDRESS1_"
"LK_SA_LOCATION"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADDRESS1_LK_SA_LOCATION does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADDRESS2_"
"LK_SA_LOCATION"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADDRESS2_LK_SA_LOCATION does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADDRESS3_"
"LK_SA_LOCATION"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADDRESS3_LK_SA_LOCATION does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADJ_NAME_"
"LK_SA_ADJ"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADJ_NAME_LK_SA_ADJ does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADJ_NAME_"
"LK_SA_PRE_ADJ"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADJ_NAME_LK_SA_PRE_ADJ does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ALIAS_LK_"
"SA_USER"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ALIAS_LK_SA_USER does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1

Report message to a moderator

Re: Import Problem [message #134041 is a reply to message #134008]

Tue, 23 August 2005 07:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

NO information on Oracle versions involved and OS.
First check you have the concerned object in a good state.
Make sure the object (trigger and the base table) or the owner of object (schemaname) is not created with " (quotes) around as seen in here.

"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1','"BI_BU_ADDRESS1_LK_SA_LOCATION"', FALSE); END;"

Report message to a moderator

Re: Import Problem [message #134046 is a reply to message #134008]

Tue, 23 August 2005 07:24

sszssz
Messages: 2
Registered: August 2005
Location: alwa

Junior Member

can i see your import statement.it seems version compatibility issuse here.

Report message to a moderator

Re: Import Problem [message #134054 is a reply to message #134046]

Tue, 23 August 2005 07:50

balasmg
Messages: 31
Registered: June 2005
Location: bangalore

Member

I have taken the dump in 8i.
I imported the same in 9i.
os - sun solaris
The errors comes after importing all the datas .

Report message to a moderator

Re: Import Problem [message #134061 is a reply to message #134008]

Tue, 23 August 2005 08:00

balasmg
Messages: 31
Registered: June 2005
Location: bangalore

Member

Hi
For your information the data taken from
From user : 8i user is TEST42-MS1
To User : 9i user is TEST42_NEW

pl. let us know is there any version compatibilty
if so, how to recify it

Report message to a moderator

Previous Topic:	sql loader and line feed
Next Topic:	need help with sql-loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 19:36:06 CST 2024