Home » Developer & Programmer » Designer » creation of database
creation of database [message #90678] Fri, 23 July 2004 01:51 Go to next message
Messages: 74
Registered: March 1999
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
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: 4569
Registered: April 1998
Senior Member

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


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.

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

Current Time: Sun Jun 20 17:15:16 CDT 2021