Re: oracle 11g: how to export related data from tables
From: joel garry <joel-garry_at_home.com>
Date: Mon, 20 Jan 2014 15:33:33 -0800 (PST)
Message-ID: <8a4351b3-de19-4912-b0f0-3b766e5c66db_at_googlegroups.com>
Date: Mon, 20 Jan 2014 15:33:33 -0800 (PST)
Message-ID: <8a4351b3-de19-4912-b0f0-3b766e5c66db_at_googlegroups.com>
On Monday, January 20, 2014 2:55:23 PM UTC-8, rgr..._at_gmail.com wrote:
> Hi, I have a question:
>
> I must export same part od data (same records) from the base table T1 and all related data from another tables T2, T3, etc. The data are related by constraints. How can I do it ?
>
>
>
> Thanks for halp...
>
>
>
> Regards
>
> Robert
You can look at http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_1037.htm#i1576022 user_constraints of type R to get the table names.
Then build a parfile from that.
jg
-- _at_home.com is bogus. http://www.thenational.ae/business/industry-insights/technology/dubais-smart-city-plans-spark-oracle-hiring-spreeReceived on Tue Jan 21 2014 - 00:33:33 CET