Skip to Main Content

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!

How can I resize a sysaux tablespace?

473071Apr 23 2007 — edited Apr 23 2007
Hi mates,
Can Anyone pls tell me how to increase the size of a sysaux tablespace as I have just 0.91% of free space on my sysaux tablespace.
Can it be increased just like any other tablespace in 10g.... using the command:


"alter database datafile 'datafile' resize XXXM; "

If this is not the way , pls let me know...
Cheers.
Kenny................
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2007
Added on Apr 23 2007
4 comments
1,075 views