RE: Not able to find data file on server but database is working fine

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <Harvinder.Singh@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 22 Jun 2007 14:03:03 -0600

Is this an ASM managed instance?  

--
Ron Reidy
Lead DBA

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh
Sent: Friday, June 22, 2007 1:18 PM
To: oracle-l@xxxxxxxxxxxxx
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

 
--
//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.
--
//www.freelists.org/webpage/oracle-l


Other related posts: