When Creating Domain for Oracle SOA it’s Mandatory to Run Oracle RCU before to create SOA Repository, This will create tables configuration and information about Oracle SOA.
But What happened the this tablespace was getting full, increase it 20GB is not enough which mean it’s strange case and not acceptable.
after investigation Table Called “REFERENCE_INSTANCE” include information about Running Composite in SOA ans instances. the size for this table 18GB.
Select * from Reference_instance;
Check the data in the above query, just in case you can use export data-bump utility for this table, however after this Truncate the table and from full tablespace toonly 2% usage.
Published by Osama Mustafa
Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.
In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.
Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.
View all posts by Osama Mustafa