Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Single or multiple tablespaces

user325480Jan 16 2012 — edited Jan 17 2012

Hi All,

Need a suggestion. Currently we have our data in one tablespace and contains around 200+ tables. Is it good to keep on a single tablespace or need to spread data on some logical grouping to different tablespaces. Oracle version is 11g and using locally managed tablespaces with AUTOALLOCATE.

Regards,
vara.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2012

Added on Jan 16 2012

#dba, #general-database-discussions

15 comments

4,209 views