Re: Get the following error when renaming datafiles from inside a sql script

> PROMPT Taking tablepsace offline...
>
> PROMPT Copying datafile to new location...

Where is the command to take the tablespace offline? It was missing from the script you posted. The database never took the tablespace offline therefore you can't rename a file if the database thinks that the tablespace's datafile is active. That is what the error messages are telling you. Move the datafile back, apply recovery, and try again.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"