moving ts

how do i move data files for a ts to another directory? my task is to move XXX_DATA ts to E: drive. os is win2k, oracle is 8.1.7.

Move the datafile and recreate the controlfile.

Tablespace cannot be moved but the datafile.

Take the TS offline.
Move the datafiles to other location.
Use the RENAME DATAFILE part of ALTER TABLESPACE command.

Hi

This link should help you.Try to make a search on this forum you will find tons of info by just searching

http://dbasupport.com/forums/showthr...threadid=17111

Regards

Hi.

CONNECT sys/password AS SYSDBA
SHUTDOWN IMMEDIATE

-- Move the file to the new location using Windows Explorer

STARTUP MOUNT PFILE=ORACLE_BASE/admin/SID/pfile/init.ora
SELECT name FROM v$datafile;
ALTER DATABASE RENAME FILE 'E:\ORADATA\SID\file.dbf' TO 'F:\ORADATA\SID\file.dbf';
ALTER DATABASE OPEN;

The rename won't work if you put in incorrect stuff so don't worry.

Obviously, substitue you path details. The select is just to remind you.

Sometimes NT/2000 gets a bit funny about moving files unless the service is switched off. If explorer won't let you move the file switch the service off using the services dialog:

Start->Programs->Administrative Tools->Services (2000)
Start->Settings->Control Panel->Services (NT 4.0)

or use:

C:> NET STOP OracleServiceSID

You might want to do a backup before you start. You should definitely backup the controlfile once you've finished.

Have a good one.

Wow! In the time it took me to type the answer 3 people had already got in. I need typing lessons :)