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:50:48 CDT