CODEWITHSUNDEEP
oracle-database
AJM
AJM

Reputation: 32490

Oracle TEMPORARY TABLESPACE

I want to import a database to a new tablespace.

So I;m setting up a user using CREATE USER. But how do I set up the TEMPORARY TABLESPACE if I don't know the temporary tablespace the existing database uses?

Upvotes: 2

Views: 612

Answers (2)

RC.
RC.

Reputation: 28267

If you are creating a user and don't specify a temporary tablespace, it should get set to the default. This can be found by:

SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

If you want to find other TEMPORARY tablespaces within the database you can do:

SELECT * FROM dba_tablespaces WHERE contents = 'TEMPORARY' ORDER BY tablespace_name;

Upvotes: 3

Quassnoi
Quassnoi

Reputation: 425813

SELECT  temporary_tablespace
FROM    dba_users
WHERE   USERNAME = 'SCOTT'

Upvotes: 2

Related Questions