create DB

[jmodic]

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.