Skip to Main Content

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!

How to get the default path of data file of a table space

user1095915Feb 18 2016 — edited Feb 23 2016

I used below sql statement to create a table space:

CREATE TABLESPACE AAA DATAFILE BBB SIZE 10M AUTOEXTEND OFF ...

Notice, i did not give a full path instead just a file name, then query relevant tables to

get the full path of this data file, let's assume it is below path:

d:\oracle\...\BBB

So i do believe there is a default path that oracle can use it to create data file. My question

is how to get this default path before i create a table space.

Thanks a lot.

This post has been answered by InquisitiveDBA on Feb 18 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2016
Added on Feb 18 2016
14 comments
23,332 views