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.
OCP DBA 8i
When in doubt, pick 'C'.
Move the datafile and recreate the controlfile.
Tablespace cannot be moved but the datafile.
To handle yourself, use your head. To handle others, use your heart
Take the TS offline.
Move the datafiles to other location.
Use the RENAME DATAFILE part of ALTER TABLESPACE command.
This link should help you.Try to make a search on this forum you will find tons of info by just searching
CONNECT sys/password AS SYSDBA
-- 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)
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
Click Here to Expand Forum to Full Width