Home » RDBMS Server » Server Utilities » Data pumps import issue (linux)
Data pumps import issue [message #627756] Sat, 15 November 2014 13:04 Go to next message
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
Re: Data pumps import issue [message #627757 is a reply to message #627756] Sat, 15 November 2014 13:27 Go to previous messageGo to next message
BlackSwan
Messages: 26538
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
Re: Data pumps import issue [message #627758 is a reply to message #627756] Sat, 15 November 2014 14:25 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You must first be sure then they have been exported!

Re: Data pumps import issue [message #627997 is a reply to message #627758] Tue, 18 November 2014 13:43 Go to previous messageGo to next message
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.
Re: Data pumps import issue [message #627998 is a reply to message #627997] Tue, 18 November 2014 13:46 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
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?


Re: Data pumps import issue [message #627999 is a reply to message #627997] Tue, 18 November 2014 13:48 Go to previous messageGo to next message
BlackSwan
Messages: 26538
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
Re: Data pumps import issue [message #628853 is a reply to message #627998] Sat, 29 November 2014 06:22 Go to previous messageGo to next message
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
Re: Data pumps import issue [message #628855 is a reply to message #628853] Sat, 29 November 2014 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
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!


Re: Data pumps import issue [message #628861 is a reply to message #628855] Sat, 29 November 2014 07:28 Go to previous messageGo to next message
altaffdba
Messages: 7
Registered: November 2014
Location: hyderabad
Junior Member
Ok i will go through the manual.
Thanks
Re: Data pumps import issue [message #628863 is a reply to message #628861] Sat, 29 November 2014 07:33 Go to previous messageGo to next message
BlackSwan
Messages: 26538
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/
Re: Data pumps import issue [message #628866 is a reply to message #628861] Sat, 29 November 2014 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
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.

Re: Data pumps import issue [message #628934 is a reply to message #628866] Mon, 01 December 2014 04:51 Go to previous message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
Quote:

Manual (unless it is the name of your colleague)

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


Current Time: Sat Jun 15 20:25:12 CDT 2019