OraFAQ Forum: Server Utilities » Data pumps import issue

Home » RDBMS Server » Server Utilities » Data pumps import issue (linux)

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

Data pumps import issue [message #627756]

Sat, 15 November 2014 13:04

altaffdba
Messages: 7
Registered: November 2014
Location: hyderabad

Junior Member

Hi experts
Iam trying to import a schema. But constraints are not getting created. What parameter should i mention while exporting and importing.
Thanks

Report message to a moderator

Re: Data pumps import issue [message #627757 is a reply to message #627756]

Sat, 15 November 2014 13:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

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

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

expdp help=yes
impdp help=yes

Report message to a moderator

Re: Data pumps import issue [message #627758 is a reply to message #627756]

Sat, 15 November 2014 14:25

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You must first be sure then they have been exported!

Report message to a moderator

Re: Data pumps import issue [message #627997 is a reply to message #627758]

Tue, 18 November 2014 13:43

altaffdba
Messages: 7
Registered: November 2014
Location: hyderabad

Junior Member

Thanks for the response. I would like to know about the TRANSFORM paramater use. What is meant by transform=oid:n
what happens when i issue the above parameter during import.

Report message to a moderator

Re: Data pumps import issue [message #627998 is a reply to message #627997]

Tue, 18 November 2014 13:46

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What does this have with the previous question?
Did you find the answer,?
What was the problem?

Report message to a moderator

Re: Data pumps import issue [message #627999 is a reply to message #627997]

Tue, 18 November 2014 13:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

altaffdba wrote on Tue, 18 November 2014 11:43

Thanks for the response. I would like to know about the TRANSFORM paramater use. What is meant by transform=oid:n
what happens when i issue the above parameter during import.

when all else fails Read The Fine Manual

https://docs.oracle.com/database/121/SUTIL/dp_import.htm#SUTIL939

Report message to a moderator

Re: Data pumps import issue [message #628853 is a reply to message #627998]

Sat, 29 November 2014 06:22

altaffdba
Messages: 7
Registered: November 2014
Location: hyderabad

Junior Member

Hi all sorry for responding late.my issue still unresolved. While importing synonymns not getting imported.
how to resolve.
Thanks

Report message to a moderator

Re: Data pumps import issue [message #628855 is a reply to message #628853]

Sat, 29 November 2014 06:28

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Michel Cadot wrote on Sat, 15 November 2014 21:25

You must first be sure then they have been exported!

Report message to a moderator

Re: Data pumps import issue [message #628861 is a reply to message #628855]

Sat, 29 November 2014 07:28

altaffdba
Messages: 7
Registered: November 2014
Location: hyderabad

Junior Member

Ok i will go through the manual.
Thanks

Report message to a moderator

Re: Data pumps import issue [message #628863 is a reply to message #628861]

Sat, 29 November 2014 07:33

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/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Re: Data pumps import issue [message #628866 is a reply to message #628861]

Sat, 29 November 2014 07:46

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

altaffdba wrote on Sat, 29 November 2014 14:28

Ok i will go through the manual.
Thanks

This is not a question of manual.
Manual (unless it is the name of your colleague) will not tell you if you have exported the synonyms or constraints.

Report message to a moderator

Re: Data pumps import issue [message #628934 is a reply to message #628866]

Mon, 01 December 2014 04:51

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

Manual (unless it is the name of your colleague)

Report message to a moderator

Previous Topic:	Is Datapump Export is Possible in Oracle Client
Next Topic:	Wrap Utility doesn't work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 25 00:32:07 CDT 2023