OraFAQ Forum: Server Utilities » import error (urgent plz)

Home » RDBMS Server » Server Utilities » import error (urgent plz)

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

import error (urgent plz) [message #479778]

Tue, 19 October 2010 05:16

muradjuber
Messages: 60
Registered: August 2010

Member

Dear Experts

Can Anyone guide me

i prepare database server
and when i import my dump file from old database
it import normal but before it end
it give me these errors and these errors it seems that it in loop

IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 12:
PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored

Report message to a moderator

Re: import error (urgent plz) [message #479786 is a reply to message #479778]

Tue, 19 October 2010 05:52

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

Senior Member
Account Moderator

"plz"? what does a german post code has to do here?
"urgent"? How is it urgent for us to answer your question?

What should be urgent is for you to read OraFAQ Forum Guide and post complete information.
For instance, posting the Oracle versions (with 4 decimals) of both source and target databases is a minimum.
As well as both export and import statements you executed.
Don't you think?

Regards
Michel

Report message to a moderator

Re: import error (urgent plz) [message #479787 is a reply to message #479786]

Tue, 19 October 2010 05:53

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

Senior Member
Account Moderator

In addition, do NOT multipost your questions but post it in the appropriate (sub)forum.
Duplicates are deleted.

Regards
Michel

Report message to a moderator

Re: import error (urgent plz) [message #479789 is a reply to message #479778]

Tue, 19 October 2010 06:01

muradjuber
Messages: 60
Registered: August 2010

Member

iam sorry

but i was very sad from this error

i do this command

imp user/pass file="dumpfilepath"

Report message to a moderator

Re: import error (urgent plz) [message #479792 is a reply to message #479786]

Tue, 19 October 2010 06:04

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Michel Cadot wrote on Tue, 19 October 2010 11:52

For instance, posting the Oracle versions (with 4 decimals) of both source and target databases is a minimum.
As well as both export and import statements you executed.

Michel has asked for four pieces of information there. You've given us one.

Report message to a moderator

Re: import error (urgent plz) [message #479795 is a reply to message #479792]

Tue, 19 October 2010 06:17

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

Senior Member
Account Moderator

Quote:

You've given us one.

And an invalid one! Wink

Regards
Michel

Report message to a moderator

Re: import error (urgent plz) [message #479804 is a reply to message #479795]

Tue, 19 October 2010 07:42

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

If am correct this issue occurred in 10g R2.

Refer this document to resolve this issue "Schema Import fails with PLS-201: Identifier 'SYS.DBMS_EXPORT_EXTENSION' Must Be Declared [ID 445135.1]"

Babu

Report message to a moderator