Re: Problem renaming a Tablespace Datafile in 10.2.0.4

> That simple answer is:
>
> 1) Copy or rename the datafile at the O/S level BEFORE attempting to
> rename it in the database.  Take the tablespace offline, copy the
> datafile to the proper name,  rename the datafile in the database,
> recover the tablespace and then bring the tablespace online.  You
> should then be able to drop the old datafile at the O/S level.
> 'Renaming' the datafile in the database merely updates the data
> dictionary, it does NOT rename files at the O/S level.
>
> David Fitzjarrell

Thank you very much David all sorted now. I'd wrongly assumed that 10G would also perfom the action at OS level as it does at deleting tablespace datafiles when a tablespace is dropped.

Best regards
John Received on Mon Jan 11 2010 - 09:01:34 CST