Re: Moving database
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 11 Aug 2011 06:13:40 -0700 (PDT)
Message-ID: <6518b899-e0d7-4c4a-8b36-fccf78a71ad4_at_c8g2000prn.googlegroups.com>
On Aug 10, 3:57 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Uffe Kousgaard" <o..._at_no.no> a écrit dans le message de news: 4e42ceac$0$312$14726..._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
Date: Thu, 11 Aug 2011 06:13:40 -0700 (PDT)
Message-ID: <6518b899-e0d7-4c4a-8b36-fccf78a71ad4_at_c8g2000prn.googlegroups.com>
On Aug 10, 3:57 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Uffe Kousgaard" <o..._at_no.no> a écrit dans le message de news: 4e42ceac$0$312$14726..._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
Before attempting to move your database files I suggest you look in the DBA Administration manual which has a section on how to move the database data files. For user tablespaces you also have the option of just altering the tablespace offline, alter tablespace rename datafile, copying the file at the OS level, bringing the tablespace back online, accessing data to prove to yourself everything is fine, then removing the original file. Naturally this will not work for the system tablespace but alter database rename datafile will. To move the temp tablespace I would just drop and recreate it after starting the database instance in restricted mode.
HTH -- Mark D Powell -- Received on Thu Aug 11 2011 - 08:13:40 CDT