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!

Alter Table Space Autoextend

Naseer CHVTJun 9 2010 — edited Jun 9 2010

Hi,
I got an Error like this

"ORA-01630 max # extents (string) reached in temp segment in tablespace string
Cause: A temporary segment tried to extend past MAXEXTENTS."

Is it possible to alter table space to Auto Extend in Oracle 8i With out Shutting down the
Database. What Exact Commands for this? Is this effect the performance of the database?

Please reply
With thanks Naseer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2010

Added on Jun 9 2010

#general-database-discussions

4 comments

2,049 views