Moving Oracle Datafiles to a New ASM Group in Azure Storage

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.