posted this on the APPS Dba forum by mistake so am reposting here....

Heres a bit of a question I got asked ...

OFA says "Seperate tables and indexes into different tablespaces" - Ok, fair enough. But then SYSTEM contains both tables and indexes. The question I got asked was - can you split this to two tablespaces - say INDEX_SYSTEM and TABLES_SYSTEM and alter table move tablespace the objects out of system.....

Im guessing that you cant, but has anyone attempted this. Dont get me wrong here - im not suggesting this is a good idea, its just a matter of nerdy interest.....

-Bob