create database [message #63475] |
Fri, 08 October 2004 01:21 |
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 #63480 is a reply to message #63478] |
Fri, 08 October 2004 03:51 |
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 |
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
|
|
|