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$426a34cc_at_news.free.fr>
Date: Wed, 10 Aug 2011 21:57:04 +0200
Message-ID: <4e42e297$0$7280$426a34cc_at_news.free.fr>
"Uffe Kousgaard" <oh_at_no.no> a écrit dans le message de news: 4e42ceac$0$312$14726298_at_news.sunsite.dk...
|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.
Regards
Michel
Received on Wed Aug 10 2011 - 14:57:04 CDT