CODEWITHSUNDEEP
plsqloracle11g
Nur
Nur

Reputation: 1

Where can I find the default path for a tablespace if I did not specify one

So I created a tablespace without specifying path. What do I do in this case.Somewhat related but how do I create a n Sql script on Sql dev?

1

I tried creating a path after that but I couldn't

Upvotes: 0

Views: 36

Answers (1)

Paul W
Paul W

Reputation: 11274

It will get created under whatever path the parameter db_create_file_dest specifies.

In SQL Plus, type show parameter db_create_file_dest or query v$parameter.

If that parameter is not defined, it should create it in $ORACLE_HOME/dbs , which you probably don't want it to do.

Upvotes: 2

Related Questions