Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

default and temporary

Posted on 2014-04-22
2
Medium Priority
?
246 Views
Last Modified: 2014-04-24
How we will find the default and temporary tablespace for a schema..
0
Comment
Question by:vangogpeter
2 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 2000 total points
ID: 40015611
select default_tablespace,temporary_tablespace from dba_users where username=<user_name>
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40015619
>>How we will find the default and temporary tablespace for a schema..

select USERNAME, DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE from dba_users where username='SOMESCHEMA';

or if connected as the schema owner:
select DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE from user_users ;
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question