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 -> No full pathname in field file_name of dba_data_files

No full pathname in field file_name of dba_data_files

From: wangz <php_at_yeah.net>
Date: 13 Jan 2002 19:16:02 -0800
Message-ID: <6f77ff2a.0201131916.5ce13216@posting.google.com>


Some backup tools need to extract full path from dba_data_files to backup the datafile,but some record of dba_data_files in my oracle database only show filename,no path is include. can anybody tell me what it occured,and how can I restore the field only include filename to filename with full path.

Os: WINNT4.0
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production

SQL> select file_name,tablespace_name from dba_data_files;

FILE_NAME                              TABLESPACE_NAME
-------------------------------------- --------------------
C:\ORANT\DATABASE\SYS1ORCL.ORA         SYSTEM
C:\ORANT\DATABASE\RBS1ORCL.ORA         RBS
C:\ORANT\DATABASE\USR1ORCL.ORA         USR
C:\ORANT\DATABASE\TMP1ORCL.ORA         TEMPORARY
C:\ORANT\DATABASE\INDX1ORCL.ORA        INDX
C:\ORANT\DATABASE\DRORCL.ORA           DRSYS
C:\ORANT\DATABASE\IMAGE.ORA            XFB_IMAGE
MIG_DATA                               MIG_DATA
MIGTMP                                 MIGTMP
MIGDATA1                               MIG_DATA
INX_MIG.ORA                            INX_MIG
MIG_FLOW1.ORA                          MIG_FLOW
MIG_FLOW2.ORA                          MIG_FLOW


Thanks!
Wangz Received on Sun Jan 13 2002 - 21:16:02 CST

Original text of this message

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