Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Issue upgrading to 10g
bdbafh_at_gmail.com schrieb:
> If you lack temp files, a query against dba_temp_files will throw an
> error.
> Query v$tempfile instead to see what tempfiles are missing.
>
Not necessarily:
sys_at_ORA102> select file_name,tablespace_name from dba_temp_files;
FILE_NAME TABLESPACE_NAME ---------------------------------------- ---------------/opt/oracle/oradata/ORA102/temp01.dbf TEMP
sys_at_ORA102> select tablespace_name from dba_tablespaces
2 where contents='TEMPORARY';
TABLESPACE_NAME
sys_at_ORA102> !ls /opt/oracle/oradata/ORA102/temp01.dbf ls: /opt/oracle/oradata/ORA102/temp01.dbf: No such file or directory
sys_at_ORA102> select file_name from dba_temp_files;
FILE_NAME
Best regards
Maxim Received on Wed Feb 08 2006 - 14:46:31 CST