I´m planning to put some tables in a separate tablespace/filesystem. Is there a restriction ?
Oracle EBS 11.5.10.2. Oracle Database 10.2.0.4 on AIX 5.3
I´m about to reorganize the Oracle Inventory (INV) tables after running a huge purge. The MTL_MATERIAL_TRANSACTIONS table is accessed a lot and I´d like to put it in a different tablespace than APPS_TS_TX_DATA (OATM). This SPECIAL tablespace will be created in a separate JFS2 filesystem. I´ll do the same with the table indexes, they will be in their own tablespace/filesystem.
Is there a restriction? Why shouldn´t I do that? Could I have problems applying patches?
I´m about to reorganize the Oracle Inventory (INV) tables after running a huge purge. The MTL_MATERIAL_TRANSACTIONS table is accessed a lot and I´d like to put it in a different tablespace than APPS_TS_TX_DATA (OATM). This SPECIAL tablespace will be created in a separate JFS2 filesystem. I´ll do the same with the table indexes, they will be in their own tablespace/filesystem.
Is there a restriction? Why shouldn´t I do that? Could I have problems applying patches?
0