Max Extents increase
Any ideas how to raise max extents of tables within Oracle database?
thanks
IT Employment
Any ideas how to raise max extents of tables within Oracle database?
thanks
by jim.schromm
I'm not an Oracle expert but this may help.
http://www.cryer.co.uk/brian/oracle/ORA01631.htm
by barry.c.john
by d. brinson
You must have security to alter the table. If you do, the following command should work:
alter table TABLENAME storage (maxextents NEW_VALUE);
where TABLENAME is the name of your table
and NEW_VALUE is your new extent size (for example 5 or200
If you use scripts to create your database, you must be sure to change the scripts to reflect your new extent size.
by barry.c.john
by barry.c.john
This discussion is closed to new replies.
Sort by Trending