I don't think so ,U can use the env variable in SQL.


Sanjiv


-----Original Message-----
From: Jitendra Kamble [mailto:Jitendra.[Email Address Removed] Monday, December 30, 2002 11:52 AM
To: LazyDBA.com Discussion
Subject: env Variable in Create Tablespace


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page