Re: Importing existing tables

Answers embedded.

Hth,

Sybrand Bakker, Oracle DBA

Marian ZUREK <zurek_at_cern.ch> wrote in message news:Pine.LNX.3.95a.1000215150551.7211K-100000_at_pcst292...
> Hi,
>
> I have an export file containing several tables and now
> want to import some of them but NOT ALL.

imp .... tables=(table1,table2, table3...)

>
> The other issue is that the tables being stored in the exported file
> already exist in my DB context. Can I somehow change their names/import
> under different names and avoid overwriting.
No, you can't change the names. Import them to a dummy account (use fromuser=xyz and touser=dummy on the commandline)
>
> Do I need another account for that ?
>
> Thanks for any help/suggestions.
>
> Regards,
> Marian ZUREK
>
>
> *********************************
> * Marian Zurek *
> * CERN *
> * CH-1211 GENEVE 23 *
> * e-mail: Marian.Zurek_at_cern.ch *
> *********************************
>
>
>
Received on Tue Feb 15 2000 - 00:00:00 CET