| Creating a new oracle db from delphi [message #104784] |
Tue, 01 February 2005 07:00 |
Faruk Demirel
Messages: 1
Registered: February 2005
|
Junior Member |
|
|
Hi every body;
I am trying to use "TOAD generated oracle db createion script, (.bat, .ora and .sql)" to create a new database programmatically.
I have an oracle 9i on a w2k3server.
The toad generated script works fine and creates a new db instance when I dblclicked on the bat file.
My program generates an sql script file, an ora file and implements the bat file command internally.
the generated files are exatcly the same with the TOAD generated ones except, my program replaces the parameter fields of TOAD files (eg: %ORACLE_BASE%) fields with the real ones (eg:e:oracle...) and writes them in to the proper folders like this.
%oraclebase%admin%sid%pfileinit%sid%.ora
%oraclebase%admin%sid%createinit%sid%.ora
%oraclebase%admin%sid%createcreate%sid%.sql
%oraclehome%databaseinit%sid%.ora
and finally calls the orapwd, oradim, sqlplus and oradim again one by one.
But it fails. I can not able to solve this problem.
Both of the toad generated scripts and myscripts are available for your eyes on: www.coderium.com/orascripts.rar
Also my code is in this archive.
Any help appreciated.
regards.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
