|
-
just to confirm,
spool myfile.sql
set trimspool on
set pages 0
set linesize 222
select 'alter database rename file ''' || file_name || ''' to d''' || substr(2,len(file_name),file_name) | ';'
select 'alter database rename file ''' || member || ''' to d''' || substr(2,len(member),member) | ';'
spool off
Myfile = file that I will convert to an sql file generated by the V$datafile query
file_name = is a field in the myfile query right??
d''' - is this my drive
Or this is the script I need to run , I would just be editing the converted file.
To you all thanks for help, and Merry Christmas
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
|