When you install Oracle on your system, for the first time, and you choose to have the first database created, Oracle places the data files in one directory while placing the files related to DBA in another directory, both of which are placed in, yet another directory. The general setup is like this for datafiles c:\oracle\oradatat\db_name, likewise the setup is like this for dba related files c:\oracle\admin\db_name.
When you create a database manually you can "specify" where you want ALL of your files to be located, for example, when I create a database here is how I lay it out c:\db_name, then follows all of the directorys inside the db_name directory. There will be files that must be fetched from c:\oracle\ora_whatever, but the gist, for me, is convenience
Hop I helped.
Rick
Rick
Sigh.....those were the days my friend, I thought they'd never end.
I too remember when this place was coo.
Davey23UK said it, creating a database manually gives the dba more controll over creating the structure, the majority of the files, and where those files are located.
See here.
Manually
c:
ACME--->data, create, pfile, udump, cdump, bdump, control1, control2, redo1, redo2, backup, scripts. This is just the start. Keep in mind, as Davey23UK stated, when you create a database manually you must also create the pfile, and that will be determined by what parameters will be required by those needs of the people you work for.
Creating a database automatically forces the dba to have to wade through 3 directories, it's sub-directories to manage the database, creating a database manually places the bulk of the files in
ONE ONE directory, of course it's sub-dirctories as well.
It's ease of management.
Rick
Rick
Sigh.....those were the days my friend, I thought they'd never end.
I too remember when this place was coo.
Originally posted by julian I have created 100s of databases, never used the assistant though...
Created hundreds of database, huh? So I guess your entire DBA's career is more or less concentrated around new databases creation, isn't it? Or was that number slightly exagerated?
I've not created even close to one hundred databases in my entire Oracle life (which is allready deep into its second decade now), however I have created quite a few of them with the help of Oracles's "database assistant" since it was made available in 8i. And I say thank god they provided such a tool. Maybe not for someone who creates at least one new database everery day (given it a second thought, I think this tool was ment in particular for them!), but for a typical DBA such an assistant is a god-sended tool, particulary when it enables him to save creation scripts and browse to them (and probably manualy change few bits in them) before running them.
And if you realy never used it as you say, then I assure you you are wasting your time by creating them manualy. Realy, you should give it a try some day... You'd be surprised what interesting options this assistant provide - in particular those templates are made just for the type of DBAs that are forced to create hundreds or thousands of databases.
Last edited by jmodic; 01-11-2004 at 03:00 PM.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Reply With Quote
Bookmarks