batch file
Hi,
CREATE TABLESPACE user_index
DATAFILE
%MyPath%\ORADATA\XE\IDX.DBF' SIZE 1024 M
AUTOEXTEND ON NEXT 100 M MAXSIZE UNLIMITED;
It's possible create a file when i run this statement in sqlplus or worksheet?
In addition to running need to specify the parameter path?
How?!
it's my file Tab_espace.sql:
CREATE TABLESPACE user_index
DATAFILE
%MyPath%\ORADATA\XE\IDX.DBF' SIZE 1024 M
AUTOEXTEND ON NEXT 100 M MAXSIZE UNLIMITED;
My batch file:
I can create batch file:
...
sqlplus -S %userp%/%passp%@%conp% @Tab_espace.sql %MyPath%
How do i do pass parameter to file tab_espace.sql?
Regards
Jomar
0