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\confi g\scripts\init.ora

one line looks like this:
control_files=("C:\oraclexe\oradata\XE\control.dbf ")

"Uffe Kousgaard" <oh (AT) no (DOT) no> a écrit dans le message de news: 4e42ceac$0$312$14726298 (AT) news (DOT) sunsite.dk...
And use ALTER DATABASE to indicate to Oracle you moved its files.

Regards
Michel

On Aug 10, 3:57*pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

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 --