Skip to Main Content
Forums

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!

Tablespace resize

753818Sep 4 2010 — edited Sep 7 2010
Using a Bigfile tablespace (maxsize 250G) in Oracle 10g on Solaris.

In bigfile tablespace I cannot add a second datafile like normal tablespace.

Want to know when the tablespace reaches the maxsize 250G, what options do I have?

Can I increase the maxsize ?

If I re-size the datafile will it tamper the data in any way?

Sid

Edited by: online_dba@rediffmail.com on Sep 4, 2010 7:59 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2010
Added on Sep 4 2010
#general-database-discussions
11 comments
3,062 views