RE: Expdp -Need to export all data of the schema and need the structure of partitioned tables(no data)
From: Larry Elkins <elkinsl_at_verizon.net>
Date: Fri, 03 Jan 2014 06:15:39 -0600
Message-id: <018f01cf087d$846f3ad0$8d4db070$_at_net>
You can use the QUERY clause for the table(s), specifying criteria that will always be false.
Date: Fri, 03 Jan 2014 06:15:39 -0600
Message-id: <018f01cf087d$846f3ad0$8d4db070$_at_net>
You can use the QUERY clause for the table(s), specifying criteria that will always be false.
Larry G. Elkins
elkinsl_at_verizon.net
Cell: 214.695.8605
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of krishna
> moorthy
> Sent: Friday, January 03, 2014 5:35 AM
> To: Oracle-L
> Subject: Expdp -Need to export all data of the schema and need the structure of partitioned tables(no
> data)
>
> Hi,
>
>
> I need to use the export all the tables in an schema but for some partitioned table i need only
> structure .
>
>
> Need help on this.
>
>
>
>
> Regards
>
> Krishna
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 03 2014 - 13:15:39 CET