Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Create index on large table
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(*)
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