Re: Tablespace

andreas.prusch_at_sintec.de wrote:
>
> If you want to change the storage clause of rollback segments you use the

Might be better to look at why rollback is exausting on populate of tables: it shouldn't, unless it has been set too low to start with. It might be that the tables are being populated with PKs and indexes created, which will cause this problem for sure. So the alternative would be to disable all keys and drop all indexes, populate, then re-enable keys and re-create indexes. It will be faster and will throw away most rollback segment space problems.

> >
> > I am getting the following Oracle error whilst populating the tables in

--
Cheers
Nuno Souto
D.C.S. P/L
e-mail: nsouto_at_acay.com.au Received on Sat Jun 13 1998 - 09:07:47 CDT