Re: Help: Recreate database script

On Wed, 18 Apr 2001 19:39:01 GMT,
u518615722_at_spawnkill.ip-mobilphone.net wrote:

>I was learning to recreate the database
>to solve the system tablespace fragments.
>I backup the controlfile to trace and got
>the file as follow:
>
 [snip]
>I change the above file to
>
>CREATE DATABASE test
> MAXLOGFILES 32
> MAXLOGMEMBERS 2
> MAXDATAFILES 32
> MAXINSTANCES 16
> MAXLOGHISTORY 1815
>LOGFILE
> GROUP 1 'C:\ORACLE\ORADATA\SHAO816\REDO03.LOG' reuse,
> GROUP 2 'C:\ORACLE\ORADATA\SHAO816\REDO02.LOG' reuse,
> GROUP 3 'C:\ORACLE\ORADATA\SHAO816\REDO01.LOG' reuse
>DATAFILE
> 'C:\ORACLE\ORADATA\SHAO816\SYSTEM01.DBF' reuse,
> 'C:\ORACLE\ORADATA\SHAO816\RBS01.DBF' reuse,
> 'C:\ORACLE\ORADATA\SHAO816\USERS01.DBF' reuse,
> 'C:\ORACLE\ORADATA\SHAO816\TEMP01.DBF' reuse,
> 'C:\ORACLE\ORADATA\SHAO816\TOOLS01.DBF' reuse,
> 'C:\ORACLE\ORADATA\SHAO816\INDX01.DBF' reuse,
> 'C:\ORACLE\ORADATA\SHAO816\DR01.DBF' reuse,
> 'C:\ORACLE\ORADATA\SHAO816\DBA1.ORA' reuse
>CHARACTER SET WE8ISO8859P1
>
>To my surprise, all my database was destroyed.
>All the datafile were put into system
>tablespace. Thanks GOD it is only test
>database. Could some body tell me what is
>the right script to re-create the database?
>
>Thanks a lot.
>

Check out the syntax for the create database statement in your manual or online at http://technet.oracle.com and you must notice only the system datafile is required. The only thing a create database does is create the system tablespace. So the behavior described above what just to be expected.
Please try to use the newsgroup as a *last* resort and not as a *first* resort, like you seem to do. The documentation is there, please use it.

Regards,

Sybrand Bakker, Oracle DBA Received on Wed Apr 18 2001 - 23:17:46 CEST