Database Creation

[rishiu]

I hv already a Database and I want to create another
database, Is there any way I can hv different name
for SYSTEM tablespace, i mean I want the second
datbase to hv a system tablespace like DEVSYSTEM.
If yes, What is the syntax?
Thks In advance
Rishi u

 

[karluk]

I would be very surprised if this turns out to be possible. As far as I know, Oracle will insist on having a SYSTEM tablespace in which to put catalog objects.

If the issue is the name(s) of the system tablespace data file(s), you should be able to name them anything you want during the create database process.