Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Not able to find data file on server but database is working fine
Is this an ASM managed instance?
--
Ron Reidy
Lead DBA
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh
Sent: Friday, June 22, 2007 1:18 PM
To: oracle-l_at_freelists.org
Subject: Not able to find data file on server but database is working
fine
Hi,
On the test machine the developer created a new tablespace and I can see in the alert.log file that the command was successful. Also I can see from dba_data_fies that the datafile is available and also the tablespace is showing as Online in dba_tablespaces. Also I am able to create and insert data into table created in this tablespace but problem is I don't see the file on server and I done search(find) as root and don't see file anywhere on the system. Where the file can be and what can be the possible reason for this behavior? Environment: Oracle 10.2.0.3 on RHAT4
Thanks
--Harvinder
--
http://www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 22 2007 - 15:03:03 CDT
![]() |
![]() |