OraFAQ Forum: Server Utilities » Getting errors during importing data

Home » RDBMS Server » Server Utilities » Getting errors during importing data (solaris, oracle 11g R2)

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

Getting errors during importing data [message #563512]

Tue, 14 August 2012 10:07

dileepdba
Messages: 3
Registered: July 2012
Location: bangalore

Junior Member

Hi All,

I am getting following errors while importing data.

SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 8, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 8, column 1:
PL/SQL: Statement ignored
ORA-06550: line 10, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored
ORA-06550: line 12, column 1:
PLS
ORA-39083: Object type INDEX failed to create with error:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 8, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 8, column 1:
PL/SQL: Statement ignored
ORA-06550: line 10, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored
ORA-06550: line 12, column 1:
PLS
ORA-39083: Object type INDEX failed to create with error:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 8, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 8, column 1:
PL/SQL: Statement ignored
ORA-06550: line 10, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored
ORA-06550: line 12, column 1:
PLS
Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
ORA-01435: user does not exist
Failing sql is:
BEGIN
SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','ARTCOCA');
END;
ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
ORA-01435: user does not exist
Failing sql is:
BEGIN
SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','RESDGENE');
END;
ORA-39083: Object type POST_TABLE_ACTION failed to create with error:
ORA-01435: user does not exist
Failing sql is:
BEGIN
SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('C509MHA','RESOBJ');
END;
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 9 error(s) at 14:48:41

Can anyone please suggest me why am getting these errors and what is the solution. These errors can ignorable ?

Report message to a moderator

Re: Getting errors during importing data [message #563514 is a reply to message #563512]

Tue, 14 August 2012 10:18

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Context is not installed in your target database
2/ ORA-01435: user does not exist ('C509MHA')

Regards
Michel

Report message to a moderator

Re: Getting errors during importing data [message #563515 is a reply to message #563514]

Tue, 14 August 2012 10:23

dileepdba
Messages: 3
Registered: July 2012
Location: bangalore

Junior Member

Hi Michel,

Actually i was trying to import objects from the schema C509MHA to GLDPRDB.
I created all necessary tablespaces and i gave all necessary grants to GLDPRDB.
I don't know what to do to avoid errors. Please suggest me...

Thanks in Advance
Dileep Kumar

Report message to a moderator

Re: Getting errors during importing data [message #563517 is a reply to message #563515]

Tue, 14 August 2012 10:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Getting errors during importing data [message #563527 is a reply to message #563515]

Tue, 14 August 2012 11:45

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to post the command and parameters you used for both export and import.
And, anyway, this will not solve point 1) that requires you installed a new Oracle component/option.

Regards
Michel

[Updated on: Tue, 14 August 2012 11:45]

Report message to a moderator

Re: Getting errors during importing data [message #563530 is a reply to message #563527]

Tue, 14 August 2012 12:06

dileepdba
Messages: 3
Registered: July 2012
Location: bangalore

Junior Member

I used following parameters to import

$impdp directory=data_pump
dumpfile=2012_08_12_empty_all_brands.dmp
logfile=2012_08_12_estimate_only.log
remap_schema=C509MHA:GLDPRDB
ignore=y
commit=y

I was not export the schema actually, I don't know what parameters they used to export schema.
My role is to import that dumpfile into the GLDPRDB schema.

What does mean oracle component/option? Need to install any package?

Report message to a moderator

Re: Getting errors during importing data [message #563543 is a reply to message #563530]

Tue, 14 August 2012 13:06

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Not a package a whole feature.

http://www.google.com/search?hl=en&source=hp&q=install+oracle+context+11g&gbv=2&oq=oracle+context+install+11

Regards
Michel

Report message to a moderator

Previous Topic:	Exp / Imp
Next Topic:	Exporting using query parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:31:58 CST 2025