Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Export/Import Utility

Re: Oracle Export/Import Utility

From: Mohamed Buhari <mbuhari_at_assigncorp.com>
Date: 12 Jan 2000 15:55:46 EST
Message-ID: <387CE9E7.64C5049C@assigncorp.com>


It can only go up to table level.So you cant import a specific record set.

Export import has got only 3 options

1.Entire DB
2.A specific user
3.A specific table within a schema.

The other options are GRANTS,INDEXES,CONSTRAINTS,COMPRESS..etc.

Alternative way is to import into another schema, using where clause, pull out those interested record sets.

Mohamed...

mc59028_at_my-deja.com wrote:

> Does anyone know if you can use Oracle Export/Import facility to
> specify specific records in a table to be exported?? Does the utility
> go down to this level??
>
> Ta in advance....
>
> KC
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 12 2000 - 14:55:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US