Re: newbie questions

Hi Robert,

You need to install Oracle on that different box first of course. If I was you I would create the database through the Instance Manager, click new instance, click advanced to change the size of the system tablespace and that should be it. Please note: this assumes the init<sid>.ora file already exist in %ORACLE_HOME%\database. <SID> is the name of your instance. You can simply take the default initorcl.ora and copy it. Do NOT forget to modify the line
control_files=
This is usually the second line of that file, and the control file names are again referring to a SID. Change orcl to the your own sid name. This procedure will take a while (something between 20 and 30 minutes depending on the speed of the server.
Then you should fire up svrmgr23.exe in a dos box, connect internal and issue the following command
create rollback segment rbtemp
tablespace system
storage (initial 100k next 100k minextents 2);

Now leave svrmgr23 and you should be ready to run imp73

As to your questions. You can't delete the SYSTEM and the ROLLBACK tablespace, they are your life blood!!!! To delete a database run the Instance Manager in GUI mode, and simply delete the instance. This will delete the database also.

Hth,

--
Sybrand Bakker, Oracle DBA
Robert Mason <rmason51_at_hotmail.com> wrote in message news:7v7154$n05$1_at_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 - 12:28:23 CDT