Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

IMP73 and EXP73

48 views
Skip to first unread message

Christophe Charron

unread,
May 7, 2001, 1:02:10 PM5/7/01
to
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 !!!!


--
Sincerely
Christophe Charron

Service Développement
PROLOGIQ
7 bis Rue des Aulnes
69410 Champagne au Mont d'Or

Tel : 0 437 499 107
Fax : 0 437 499 105
mailto:christoph...@prologiq.fr


Audun

unread,
May 8, 2001, 7:29:50 AM5/8/01
to
Try to use imp sys/manager full=y indexfile=<some file_name> and use this
file to change tablespaces ++ and create it all first. Then imp full=y
ignore=y

Audun Hansen

"Christophe Charron" <christoph...@prologiq.fr> wrote in message
news:HEAJ6.1023$0p.2...@tengri.easynet.fr...

Gary Thrower

unread,
Jul 13, 2001, 4:03:44 PM7/13/01
to
Try precreating the objects on different drive and then run the import from
that drive use ignore = Y as a parameter. You may also want to use a fromuser
= and touser= That way you can create the objects under another schema to
eliminate confusion as to where to import the data.

Regards,

Gary Thrower

0 new messages