Re: How to recreate a database

From: Thierry Poels <Thierry.Poels_at_vab.be>
Date: Fri, 23 Jul 1999 13:33:19 +0200
Message-ID: <7n9juv$rde$1@news0.skynet.be>

Hi,

The import of a full export will create all tablespaces/datafiles including temporary tablespace and rollback tablespace, rollback segments, users, database links, tables, .....

The database itself (system tablespace, control files, redo log files) has to be created manually in advance.
Other tablespaces can also be created in advance, if you want to relocate the datafiles to another disk.

good luck,
Thierry Poels
Oracle DBA & Unix Sysadmin for VTB-VAB

Maiko <maiko_at_dds.nl> wrote in message
news:37a00cc2.2682487_at_news.cistron.nl...
> I have a database, with a huge amount of datafiles. ver 7.3.4
> I exported the full database.
> Now I want to drop the whole database, recreate it and import all.
> What do I have to create? All Tablespaces with new datafiles and after
> this do the import or what?
>
> PLease help me out, or point me to a site.
> Thanks in advance,
> Maiko (maiko_at_dds.nl)
Received on Fri Jul 23 1999 - 06:33:19 CDT