Database Software

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!

Can tablespace be shared between 2 ASM diskgroups ?

885068Jan 5 2017 — edited Jan 5 2017

Hello-

I have a unique situation where my existing data disk group is almost at 99% full & my tablepsace on this DG is at 95 %. One of the solution is to create another disk-group as the back-end storage is different and attache the different storage device to this new DG & be able to get space for my database.

"Unique" in the sense the exiting disks have been exhausted & a different TYPE of storage will be added to accommodate this space need

So I'm not sure if technically this is doable or not ? Hence the question is this how one would approach ?

Adding a data file to edit the existing tablespace but having this data file from different disk group.

Database version 11.2.0.3 & 11g Grid Infra.

This post has been answered by JuanM on Jan 5 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2017

Added on Jan 5 2017

#automatic-storage-management, #performance-availability

5 comments

1,047 views