-
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
ocpwannabe@yahoo.com
-----------------------------
When in doubt, pick 'C'.
-
Move the datafile and recreate the controlfile.
Tablespace cannot be moved but the datafile.
Sam
------------------------
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.
svk
-
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
Santosh
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|