Home » RDBMS Server » Server Administration » Why Im not able to build a Index > 300M on a tablespace 2000M
Why Im not able to build a Index > 300M on a tablespace 2000M [message #56606] Fri, 11 April 2003 07:20
Cesare Giulio Summa
Messages: 6
Registered: March 2003
Junior Member
The problem is the follow:
create index xxx on tables (800M) initial 300M next 150M maxext 120.

The index is allocated but it remain in temporary state.

The rbs rollback is 300M big
Aix 5.3
Oracle 7.3.4

Thanks

Report message to a moderator

Previous Topic: User table that indicates the tables containing data
Next Topic: http server - is die .... after reboot
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:49:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.