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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle - import of dmp-files change the table name

Re: Oracle - import of dmp-files change the table name

From: Matthias Maschke <forum_at_maschke.biz>
Date: 9 Sep 2004 02:14:36 -0700
Message-ID: <9ffdb4e4.0409090114.1b63db53@posting.google.com>


> If allowed, create a new user then use the TO=newuser FROM=olduser IMP command line options to import the tables into the
> new user's schema..
>
> By granting the correct permissions you can 'see' both tables ...

Looks like the perfect way. A little bit tricky with the rights needed but exactly providing the possibilities I need. Thank you very much.

Greetings
Matthias Received on Thu Sep 09 2004 - 04:14:36 CDT

Original text of this message

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