Re: I can't find datafiles in filesystem

frankie_at_etsetb.upc.es (Francesc Guasch - Ortiz) wrote in news:d2922a01.0201101140.1b0848d3_at_posting.google.com:

> I have a working Oracle 8.1.5 instance that someone installed
> log time ago and I have no docs.
> This is Solaris 2.6.
>
> I can't file the datafiles. I search the datafiles where Oracle told
> me, and I can't find it there. I go to the directory:
> # ls -al -> returns 3 files of about 2 MB
> # du -s
>
> This returns 600 MB, this matches what Oracle told me the datafiles
> size was. .But if I do du -s * there is only 3 files of 2 MB.
>
> I need the datafiles so I can migrate this database. What is
> happening ? what can I do ? Is that in any oracle document I'm
> missing ?
>
> Thank you very much.
>

They may be using raw slices for the tablespaces. Have an Oracle DBA verify it.

-- 
-wiseguy
slummin it in Colorado ski country, while watching the IT industry move
to India, and thinking about retraining as a Sanitation Engineer


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----