RE: Expdp -Need to export all data of the schema and need the structure of partitioned tables(no data)

  • From: "Larry Elkins" <elkinsl@xxxxxxxxxxx>
  • To: <krishnamoorthykc@xxxxxxxxx>, "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 03 Jan 2014 06:15:39 -0600

You can use the QUERY clause for the table(s), specifying criteria that will 
always be false.

Larry G. Elkins
elkinsl@xxxxxxxxxxx
Cell: 214.695.8605


> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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


--
//www.freelists.org/webpage/oracle-l


Other related posts: