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!

where is the default datafile path? Thanks.

3217244Apr 9 2016 — edited Apr 9 2016

I tried the following commands:

1. create tablespace TEST_WITHOUT_PATH datafile 'TEST_WITHOUT_PATH.dbf' size 1M;

or 2. alter tablespace TEST add datafile 'TEST_WITHOUT_PATH.dbf' size 1M;

All commands execute correct, and the TEST_WITHOUT_PATH.dbf in ORACLE_HOME/database/

My instance parameter DB_CREATE_FILE_DEST is empty.

And in the book 'OCA/OCP ORACLE Database 11g', it is said 'OMF can always be overridden by specifying a datafile name in the CREATE TABLESPACE command.'

So it should be nothing with the DB_CREATE_FILE_DEST, since I specify the datafile name here.

I searched the internet, but failed to find the answer, so I asked here. Thanks.

This post has been answered by himmy on Apr 9 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2016

Added on Apr 9 2016

#general-database-discussions

6 comments

2,044 views