Home » RDBMS Server » Server Administration » need script
need script [message #185715] Thu, 03 August 2006 04:26 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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
Previous Topic: create database
Next Topic: File striping..!!!
Goto Forum:
  


Current Time: Fri Dec 02 14:30:05 CST 2016

Total time taken to generate the page: 0.06327 seconds