Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How do copy a Oracle 7.3 database with IMP73 and EXP 73 ?
An alternative to Sybrand's answer is to create the tablespaces you want to use in the new location ( call them anything you want and size them as needed)..
Then,
Create the user for the import on the new location, make the new tablespace you
created the default tablespace for that user, import using the
IGNORE=Y,FROMUSER=OLD_USER TOUSER=NEW_USER
parameters and the tables will be created in the default tablespace of the
importer ( the TO_USER parameter) since the exported tablespaces do not exist in
the new location...
"Christophe Charron" <christophe.charron_at_prologiq.fr> wrote:
>Hi,
>i want to use exp73 and IMP73 on an 7.3 Oracle Database to make tests on a
>2° database but the saved db is always restored in the original tablespace.
>And of course, I don't have enought storage on this drive. An anyway i'll
>have to move the original db on an other drive but i don't want to drop
>anything before i am not sure that the copy is ok. How can i do ? Help ...
>The sample given in
>http://technet.oracle.com/doc/server73x/SUT73/ch2.htm#toc043
>doesnt works !!!
>
>In fact, i just want to have a copy of my database !!!!
Received on Tue May 08 2001 - 12:26:03 CDT