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