Recently encountered an issue with Tablespace.
Error :
oracle.fabric.common.FabricDeploymentException: oracle.mds.transfer.TransferException:
ORA-01654: unable to extend index DEV_MDS.MDS_ATTRIBUTES_U2 by 1024 in tablespace DEV_MDS
I was unable to deploy because of the Tablespace issue. Purged all the older instances in EM as well as MDS schema unsused files / versions/ projects. I had executed all the techniques provided by Oracle documentation to purge. Finally - increased the tablespace.
SQL command:
Connect SQL with Admin user and execute the below command
alter tablespace <<MDS Schema name>> add datafile 'datafile_name' size 500m
autoextend on;
For example,my MDS scema is "DEV_MDS"
alter tablespace DEV_MDS add datafile 'datafile_name' size 500m
autoextend on;
So Friends !! .. read the Oracle documentation first. There are other techniques to clear off the tablespace issue.
No comments:
Post a Comment