I am using oracle9i R2 on win2k platform. My question is: How do we automate database creation in oracle 9i. Lets say our client is not too keen on creating the db using DBCA.. I however, used DBCA to generate scripts and have modified it accordingly eg: ORACLE_HOME, ORACLE_BASE etc. But, I am getting ORA-01092 error constantly.
Just wanted to know if anyone has tried to automate this before. If so, could you please let me know.