Home » RDBMS Server » Server Administration » need script
need script [message #185715] Thu, 03 August 2006 04:26 Go to next message
Messages: 31
Registered: April 2006
Location: Chennai

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.

Re: need script [message #185720 is a reply to message #185715] Thu, 03 August 2006 04:47 Go to previous message
Mahesh Rajendran
Messages: 10673
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
Previous Topic: create database
Next Topic: File striping..!!!
Goto Forum:

Current Time: Fri Jul 28 08:11:45 CDT 2017

Total time taken to generate the page: 0.11104 seconds