Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbie questions
Hi,
I appear to be having the same problems as Marcus' first question..
I have an export file created using :
exp73 user/password_at_tns file=export.dat log=filename.log full=y
However I need to know what is required to recreate this file on a completely different Oracle box, whats more I have very little Oracle skills so if anyone has a list of command lines which would create a new tablespace for SYSTEM and ROLLBACK so all we would have to do is run the exported file using
imp73 user/pass_at_tns file=export.dat log=import.log full=y commit=y ignore=n
Also I have another couple of questions regarding creating and deleting
(1) How do you delete the ROLLBACK and SYSTEM tablespaces once created.
(2) Is there a way to delete a database from within Oracle (rather then
deleting from within the <DATABASE> directory wihtin /ORANT.
any information would be fantastic :)
Cheers
Rob Received on Wed Oct 27 1999 - 09:11:20 CDT