hello group... my requirement is to write a sql script, that will move
datafiles around. basically, what i need to do (since we're using omf) is
retrieve the existing datafile location for a tablespace and rename it to
the new location, where i'll move it. can i do this in sql*plus
automatically??? can i use some sort of local variables to store the
name/location of the existing datafiles which i can then use via the rename
command??? thanks for any tips/examples.
al
Received on Fri Jun 17 2005 - 08:29:18 CDT
