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 -> changing location of datafiles.

changing location of datafiles.

From: Mike Mountjoy <michael_at_london.virgin.net>
Date: Wed, 27 May 1998 13:51:05 +0100
Message-ID: <6kh1tl$58e$1@nclient1-gui.server.virgin.net> 





Hi There.



I've recently archived a little used database on a machine short
of space.



I now want to reactivate this database on a different machine using the
same version of the server/OS and the same ORACLE_SID. The directory
location is different , however.



Is there a way  of doing this without first restoring the datafiles to the
orginal


machine and doing a export/import to the new machine.




Regrds,


Mike




Received on Wed May 27 1998 - 07:51:05 CDT












Original text of this message













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