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

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie questions

Re: newbie questions

From: Robert Mason <rmason51_at_hotmail.com>
Date: Wed, 27 Oct 1999 15:11:20 +0100
Message-ID: <7v7154$n05$1@grind.server.pavilion.net>


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

Original text of this message

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