Home » Developer & Programmer » Designer » creation of database
creation of database [message #90678] Fri, 23 July 2004 01:51 Go to next message
Raju
Messages: 74
Registered: March 1999
Member
Can there be more than one database in an oracle 9i server?

I can create a database while installing the Oracle server and call it 'A'. After some time i would like to create another database called 'B'. How do i create 'B' ? How does the instance for the second database start?
Re: creation of database [message #90679 is a reply to message #90678] Sun, 25 July 2004 11:52 Go to previous messageGo to next message
ellahe
Messages: 1
Registered: July 2004
Junior Member
how define number of datafiles?
Re: creation of database [message #90680 is a reply to message #90679] Sun, 25 July 2004 12:22 Go to previous message
Frank Naude
Messages: 4564
Registered: April 1998
Senior Member
Hi,

The maximum number of datafiles are defined at database creation time. Lookup the "CREATE DATABASE" command in the SQL Reference guide for details.

CREATE DATABASE ... MAXDATAFILES 1000 ...


Also, the number of datafiles accessible to your instance is limited by the INIT.ORA/SPFILE parameter DB_FILES. This is documented in the Oracle Server Reference Guide.

Best regards.

Frank
Previous Topic: Database Design
Next Topic: Oracle Designer - Maintaining Versions
Goto Forum:
  


Current Time: Thu Jul 09 01:09:05 CDT 2020