Stopping the automatic archiving of records in oracle 7

[bryantg]

Hello all...

I have a problem with a large database that can not be resized any further. How do i stop oracle from archiving records during a delete command. Is there a command that i can type just prior to the delete that will delete the records with attempting to write to a backup.

The message i receive is that failed to extend rollback segment number ## or max # extents (##) reached for rollback segment RBS_3.

Help... and Thanks. Greg Bryant
CCNP, MCP

 

[jimbopalmer]

Yes you can shutdown the data base, startup Mount, alter database noarchivelog, Open Database then when done shutdown again startup Mount and the alter database archivelog, and Open database again pretty ugly. I tried to remain child-like, all I acheived was childish.

 

[bryantg]

Jimbo,

wow..... you are right that is an ugly solution. I guess i will have to look at relocating the database to a server with more resources. thanks for the advice.....


greg Greg Bryant
CCNP, MCP

 

[jimbopalmer]

One other thing to try on an almost idle data base; for each nonsystem role back segment

Alter rollback segment RBSx offline
Drop rollback segment RBSx
Create rollback segment RBSx (specs)
Alter rollback segment RBSx online

Be sure you NEVER leave yourelf with no Rollbacks!
Be sure you know your specs before you start!
( I am writing this at home and my have syntax errors)

in oracle 7 the RBSes tend to fill up with junk this would clear that junk out without needing more room on disk.

select * from dba_rollback_segs I tried to remain child-like, all I acheived was childish.

 

[jimbopalmer]

as an example

alter rollback segment RBS0 offline;
drop rollback segment RBS0;
create public rollback segment RBS0
tablespace RBS
storage (
initial 100K
next 100K
optimal 5M
minextents 20
maxextents 100 );
alter rollback segment RBS0 online;
commit; I tried to remain child-like, all I acheived was childish.