Monday, April 27, 2015

tablespace ORA-01654 issue with Oracle SOA BPM

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