Re: Moving database

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 10 Aug 2011 21:57:04 +0200
Message-ID: <4e42e297$0$7280$>

"Uffe Kousgaard" <> a écrit dans le message de news: 4e42ceac$0$312$
|I am using oracle XE and have a folder at c:\oraclexe\oradata\XE\ with 6 DBF
| files. I want to move them to d:\ to make more room on the c-drive.
| Can I just stop the database (stopDB.bat), edit init.ora where relevant and
| then start the database again?
| c:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora
| one line looks like this:
| control_files=("C:\oraclexe\oradata\XE\control.dbf")

And use ALTER DATABASE to indicate to Oracle you moved its files.

Michel Received on Wed Aug 10 2011 - 14:57:04 CDT

Original text of this message