Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Issue upgrading to 10g

Re: Issue upgrading to 10g

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 08 Feb 2006 21:46:31 +0100
Message-ID: <dsdlb7$688$02$1@news.t-online.com>


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



TEMP sys_at_ORA102> !mv /opt/oracle/oradata/ORA102/temp01.dbf /tmp

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



/opt/oracle/oradata/ORA102/temp01.dbf

Best regards

Maxim Received on Wed Feb 08 2006 - 14:46:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US