| need script [message #185715] |
Thu, 03 August 2006 04:26  |
anandhi
Messages: 31
Registered: April 2006
Location: Chennai
|
Member |
|
|
hi
can anyone help me to create script to reorg datafile from one location to another?
Query the "dba_data_files" dictionary to know the database files related to particular tablespace
create script to take the tablespace to offline
create script to move the datafile to another location.
create script to alter the tablespace to rename the datafile
create script to bring back the tablespace to online
Pls someone help me to create script? i need as a single script.
thanks
anandhi
|
|
|
|
| Re: need script [message #185720 is a reply to message #185715] |
Thu, 03 August 2006 04:47  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
All the above are already documented in Oracle Administrator's guide.
In most cases, it is just a single Oracle sql command you have to execute against datafiles.
Spool the files and run them.
For specific examples, please search the forum, google.
The said tricks are ages old and found all over the web.
Here is a hint
http://www.jlcomp.demon.co.uk/faq/rename_datafile.html
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
