-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|