Thursday, May 21, 2015

Change data file name or location in oracle

First take the tablespace offline

alter tablespace "HMA_TM_PROD_GEN2_DATA" offline normal

Copy or mv the datafile or rename it

mv -i /oracle/oradata1/hma_tm_prod_gen2_data_03.dbf /oracle/oradata1/shsub/hma_tm_prod_gen2_data_03.dbf

Bring the tablespace back online
alter tablespace "HMA_TM_PROD_GEN2_DATA" online

Enjoy!

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...