Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create table space command with no specification of data file path.

user8680179May 15 2012 — edited May 16 2012

I am using following command for creating table space in oracle 11g
CREATE TABLESPACE testTbSpace DATAFILE 'dataFileName.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE 32767M NOLOGGING"
But it is creating datafile dataFileName.dbf at disk at following path
echo $ORACLE_HOME/dbs
I dont want to create datafile at this path and also dont want to specify data file path in 'create table space' command.

Is there is any parameter,which i can set and above command start to create dataFileName.dbf at that path

Edited by: user8680179 on May 15, 2012 1:54 AM

This post has been answered by anand prakash - oracle on May 16 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2012

Added on May 15 2012

#general-database-discussions

15 comments

1,367 views