-
tablespace
select tablespace_name from DBA_TABLESPACES
order by tablespace_name
OWAPUB
PERFSTAT
PORTAL
SYSTEM
TEMP
22 rows selected
**************************************
***********************************
select tablespace_name from dba_data_files
order by tablespace_name
OWAPUB
PERFSTAT
PORTAL
SYSTEM
56 rows selected
********************************
Now My query is , why this TEMP table space is not coming in second query?I mean why the TEMP tablespace is not coming in dba_data_files table
regards,
praveen
-
look in dba_temp_files for temporary tablespaces as it is a temp file not a data file
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|