Home » RDBMS Server » Server Utilities » Getting errors during importing data (solaris, oracle 11g R2)
Getting errors during importing data [message #563512] Tue, 14 August 2012 10:07 Go to next message
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 ?
Re: Getting errors during importing data [message #563514 is a reply to message #563512] Tue, 14 August 2012 10:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Context is not installed in your target database
2/ ORA-01435: user does not exist ('C509MHA')

Regards
Michel
Re: Getting errors during importing data [message #563515 is a reply to message #563514] Tue, 14 August 2012 10:23 Go to previous messageGo to next message
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
Re: Getting errors during importing data [message #563517 is a reply to message #563515] Tue, 14 August 2012 10:26 Go to previous messageGo to next message
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/
Re: Getting errors during importing data [message #563527 is a reply to message #563515] Tue, 14 August 2012 11:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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?



Re: Getting errors during importing data [message #563543 is a reply to message #563530] Tue, 14 August 2012 13:06 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Exp / Imp
Next Topic: Exporting using query parameter
Goto Forum:
  


Current Time: Thu Mar 28 10:29:19 CDT 2024