How many tablespaces exists in your Oracle EBS 11i Database?
OATM contains 12 locally managed tablespaces for all products, including temporary tablespace, system tablespace, and undo segments.
The previous tablespace model contained two tablespaces for each Oracle product resulting in hundreds of tablespaces.
Please see :
Oracle® Applications System Administrator's Guide - Configuration Release 12 Part No. B31453-01
=> OATM Tablespaces
Actually i read in one of the blog that use below query that last column IS_NEW_TS_MODE to check oatm is enabled or not?
Select * from fnd_product_groups;
In my case my database is having more than 12 tablespaces. i.e around 40.
But the output of the IS_NEW_TS_MODE column is Y already. SO i am confused whether OATM is present or not?
Please guide me for the same.
Pl post a list of the names of the 40 tablespaces - do these include custom tablespaces ?
Maybe you had OFA previously and converted to OATM but not all tablespaces were migrated.
Please provide us with a list of tablespaces as Srini requested earlier.