Hi,

Can I use an environment variable when creating tablespace !!!!!
e.g. in the following script, I am using ABC_ORADATA variable.

CREATE TABLESPACE USERS
DATAFILE '$ABC_ORADATA/oradata01/tst_users_01.dbf' SIZE 100M REUSE
DEFAULT STORAGE
(INITIAL 128K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS unlimited
PCTINCREASE 0
);

Please lemme know if it is possible to use or we need to specify the actual
fully qualified path !!!!

Thanks and Regards,
Jitendra Kamble


Oracle LazyDBA home page