temporary tablespace [message #50266] |
Thu, 07 March 2002 22:35 |
Jayant
Messages: 8 Registered: January 2001
|
Junior Member |
|
|
Hi,
In Oracle 817, if I create temporary tablespace using following statement
Create temporary tablespace TEMPORARY
tempfile '/Oracle/datafiles/XCALTEMP01.DBF' size 192M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 8K;
then no entry appears in the view DBA_DATA_FILES for the FILE_NAME corresponding to tablespace TEMPORARY.
Can somebody tell me a table / view that would keep the information of the FILE_NAME corresponding to tablespace TEMPORARY, even if the tablespace TEMPORARY is created using the above statement?
Thanks and regards
Jayant
|
|
|
Re: temporary tablespace [message #50268 is a reply to message #50266] |
Fri, 08 March 2002 00:53 |
shiva
Messages: 38 Registered: March 2001
|
Member |
|
|
Hi jayant,
A locally managed temporary file cannot be viewed on the list of datafiles( DBA_data_files).
Instead you can find its presence in the view
dba_temp_files.
SQL> Select file_name,file_id,tablespace_name,bytes
from dba_temp_files;
Bye
|
|
|
|
Re: temporary tablespace [message #50277 is a reply to message #50266] |
Fri, 08 March 2002 08:41 |
saleem
Messages: 65 Registered: January 2002
|
Member |
|
|
i think the whole piont about locally managed tablespaces is that they don't have dictionary entries in the same place where dictionary managed tablespaces would. check the oracle documentation about where the information should be looked at.
|
|
|