Home » RDBMS Server » Server Utilities » Datapump question
Datapump question [message #621509] Wed, 13 August 2014 21:19 Go to next message
jinga
Messages: 116
Registered: January 2003
Senior Member
Lets say we have table 1 and table 2. The primary key of table 2 comes as a foreign key in table 1. Because of the size of table 2, we exclude bringing data for table 2 by saying 1 = 2 the par file. So we only get table 2's structure. but after the import is done, table 1's foreign key is lost. we see that as a difference. I can see why it gets lost. But is there a way we can bring the foreign key definition..
Re: Datapump question [message #621510 is a reply to message #621509] Wed, 13 August 2014 21:36 Go to previous messageGo to next message
BlackSwan
Messages: 26567
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/

>But is there a way we can bring the foreign key definition..
yes via DBMS_META_DATA.

some, many, most Professional IT shops maintain application source code & DLL stored in code repository.
extract needed DDL from your local repository.
Re: Datapump question [message #621682 is a reply to message #621509] Fri, 15 August 2014 15:20 Go to previous message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ALWAYS post what you do and get when you post a question.
Do not just explain what you don't clearly understand, this does not help to know what is wrong.

Previous Topic: Load data from access database in oracle
Next Topic: sqlldr issue loading huge files
Goto Forum:
  


Current Time: Mon Jul 22 20:13:58 CDT 2019