Temp file after duplicate db

posted Mar 19, 2011, 6:29 PM by Sachchida Ojha
SQL> select tablespace_name from dba_temp_files;
TABLESPACE_NAME
------------------------------
TEMP
TEMP
SQL> select temporary_tablespace from dba_users where username='ADMN';
TEMPORARY_TABLESPACE
------------------------------
TEMP
SQL> select count(*) from dba_temp_files;
  COUNT(*)
----------
         2
SQL> desc dba_temp_files;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_NAME                                          VARCHAR2(257)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             CHAR(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER
SQL> select FILE_NAME,TABLESPACE_NAME from dba_temp_files;
FILE_NAME
------------------------------
TABLESPACE_NAME
-----------------------------
/u03/PRODDB/oradata/temp02.dbf
TEMP

/u03/PRODDB/oradata/temp01.dbf
TEMP
Comments