This article is contributed. See the original author and article here.

 

select 'ALTER TABLESPACE '||tablespace_name||' OFFLINE NORMAL;' from DBA_TABLESPACES;

select 'ALTER DATABASE RENAME FILE '''||NAME|| ''' TO '||NAME||';' from V$DATAFILES;

select 'ALTER TABLESPACE '||tablespace_name||' ONLINE;' from DBA_TABLESPACES;

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

%d bloggers like this: