Re: tablespace design for datawarehouse

Posted by ErmanArslansOracleBlog on Oct 26, 2018; 12:01pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tablespace-design-for-datawarehouse-tp6873p6879.html

If you are planning to use the OATM model, You can name your tablespaces with the following convention->

<Short_code_of_the_Application_name>_TS_<data access method>_<object_type>

Ex from EBS : APPS_TS_TX_DATA, APPS_TS_TX_IDX , APPS_TS_QUEUES etc..