Home » RDBMS Server » Server Administration » create database
create database [message #63475] Fri, 08 October 2004 01:21 Go to next message
IKRAM
Messages: 5
Registered: August 2003
Junior Member
i want to create a database in oracle 9i release 2. please guide me how i can choose the parameters theri size , number of datafiles, number of controll files.
what is the critaria to choice these parameters involve in creation of a database

ikrma
Re: create database [message #63478 is a reply to message #63475] Fri, 08 October 2004 02:09 Go to previous messageGo to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi

on which O/S you want to create that and tell me is it test/production database

Regards

kumar
Re: create database [message #63480 is a reply to message #63478] Fri, 08 October 2004 03:51 Go to previous messageGo to next message
IKRAM
Messages: 5
Registered: August 2003
Junior Member
kumar
i am using windows 2000 professional

from u r question i came to know there is difference in creation of database on basis of OS.

but at the moment i am working on windows2000 professional

take care

ikram
Re: create database [message #63481 is a reply to message #63480] Fri, 08 October 2004 04:14 Go to previous message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi

it's not exactly that, you can create the database on any O/S but the creation process is different

say for example if your using Win 2000 then simply you can go to programs select the Oracle option and select database configuration option then it will keep on ask for the options just click next then it will create a database,but if you say unix then you have to run a script called DBCA to invoke the tool.

here one point need to remember irrespective of O/S
you can create database manually by setting your own parameters (this process is bit complex) or simply by select the option called database configuration assistant tool

as you said ur using Windiws 2000 then do the following

1)select oracle option from program menu
you will find something like this
Oracle-Orahome9(click on this)

2)after that you will find sub-options select configuration and migration tools

3)then you will find a option called database configuration assistant- click on that

4)then select create database option and proceed accrding to the options which it ask you

5)after doing step 5 it will take some time to create a database this process you can see on windows...

since if you go for this options Oracle will take all the default values for creation of database,if you want to change it you can do at later stages....

take care

kumar
Previous Topic: Oracle 9i in Windows XP/2000!
Next Topic: Database links and views
Goto Forum:
  


Current Time: Fri Jan 24 23:22:53 CST 2025