Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create index on large table

Create index on large table

From: <pzankl_at_my-deja.com>
Date: Mon, 12 Jul 1999 07:57:37 GMT
Message-ID: <7mc75f$hdq$1@nnrp1.deja.com>


Hi

For I'm a newbie in the Oracle field I wanted to test some critical issues before burning my finger on hot data.

I try to create an index on large table (18M entries, Oracle 8.0.5 on Linux). After reading a lot of doc and fiddling around with (temporary) tablespaces and rollback segments I got stuck:

SQL> select count(*) from links;
 COUNT(*)



 18036260

SQL> commit;
Commit complete.

SQL> set transaction use rollback segment testrollbacksegment; Transaction set.

SQL> create index LinksIndex on Links (IDH,IDL) tablespace test3space; create index LinksIndex on Links (IDH,IDL) tablespace test3space

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1
ORA-01562: failed to extend rollback segment number 3
ORA-01650: unable to extend rollback segment R02 by 64 in tablespace RBS

SQL> commit;
Commit complete.
SQL> create index LinksIndex on Links (IDH,IDL) tablespace test3space unrecoverable;
create index LinksIndex on Links (IDH,IDL) tablespace test3space unrecoverable

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1
ORA-01562: failed to extend rollback segment number 3
ORA-01650: unable to extend rollback segment R02 by 64 in tablespace RBS

Why does Oracle complain about unextendible rollback segments when I try to tell it not to use them at all ? - Hmmpff ?

Suggestions are really appreciated.

THX, Peter

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 12 1999 - 02:57:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US