Re: max extents in temp segment in tablespace - ORA-01630

You need to do the following:

1. If you can drop the table do so, and increase th einitial size using the techniques to estimate table sizing.
2. You or the user creating/loading the table needs to be altered to point their temporary tablespace to a tablespace you must set up, generally called temp. i.e ALTER USER <username> temporary tablespace <tablespace_name>;
3. You can also alter the table itself to reduce or increase the size of the next extent.
4. If you can, specify a seprate tablespace for the primary key or other indexes, giving the correct storage parms, and tablespace name. For a Primary key the syntax can be found in the ALTER TABLE or Create TABLE commands, use the 'using index' clause.
5. To load data in a table, and to build the Primary Key / Unique indexes or other indexes, Oracle needs to sort the data. This sort occurs in the SGA if space is available, however most folks do not have enough memory, therefore Oracle does the sort on disk in the tablespace specified or if not specified in the tablespace where the table is being created. Good idea to have a tablespace set up for this temporary use. This area is also used for data retrival from a select etc.
6. The tablespace default storage parms are only used when an object being created has no storage parms specified.

Best of Luck.

Vik. Received on Thu Oct 26 1995 - 00:00:00 CET