1.

How Do We Get The Default Tablespaces Of A User?

Answer»

The FOLLOWING query GIVES the default TEMPORARY and permanent tablespace for a user:
SQL>SELECT default_tablespace,temporary_tablespace from dba_users where username='(username)';

The following query gives the default temporary and permanent tablespace for a user:
SQL>SELECT default_tablespace,temporary_tablespace from dba_users where username='(username)';


Discussion

No Comment Found

Related InterviewSolutions