Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to convert RAW <-> File datafiles of tablespace?

Re: How to convert RAW <-> File datafiles of tablespace?

From: JimmyN1 <jimmyn1_at_aol.com>
Date: 23 Sep 2001 04:16:45 GMT
Message-ID: <20010923001645.15541.00000647@mb-mv.aol.com> 






    
  
  1.   make sure you do a shutdown normal on your db so that your files are closed

  
  2.   dd your files with no offset.

  
  3.   Instead of renaming the datafile, just make a soft link from the directory
where the datafile was to the raw logical volume.  You can then move files all
around and only have to change the links.
enjoy!
example:
ln -s /dev/vg01/rdata00101 /oradata/data00101.dbf'

  
  4.   startup 



Received on Sat Sep 22 2001 - 23:16:45 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US