Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> No full pathname in field file_name of dba_data_files
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