moving ts

[ocpwannabe]

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.

[samdba]

Move the datafile and recreate the controlfile.

Tablespace cannot be moved but the datafile.

[svk]

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

[santoshym]

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

[TimHall]

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.

[TimHall]

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