| creation of database [message #90678] |
Fri, 23 July 2004 01:51  |
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 #90680 is a reply to message #90679] |
Sun, 25 July 2004 12:22  |
Frank Naude
Messages: 4590
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
