| ORA-01627 rollback segment number '1' is not online [message #125168] |
Thu, 23 June 2005 11:25  |
lnxliz
Messages: 1
Registered: June 2005
|
Junior Member |
|
|
Could someone explain to me what's happening here? I am NOT an Oracle person at all and we don't have an Oracle DBA. The server is an AIX 4.3.3 box, ML9. Though the HL7 script runs we see this error in the log:
Begin processing to remove processed rows from HL7Input and HL7Out in lhp1 database Mon Jun 20 04:00:00 EDT 2005
declare
*
ERROR at line 1:
ORA-01627: rollback segment number '1' is not online
ORA-06512: at line 18
Finished deleting Processed messages from HL7Input and HL7Out in lhp1 database Mon Jun 20 04:00:07 EDT 2005
Thank you in advance!
|
|
|
|
| Re: ORA-01627 rollback segment number '1' is not online [message #125311 is a reply to message #125168] |
Fri, 24 June 2005 06:55  |
munishmsh
Messages: 15
Registered: May 2005
Location: Bangalore
|
Junior Member |
|
|
Its trying to make use of the rollback segments which is not online.
Either make that rollback segment online (alter rollback segment .... online)else add more rollback segments to avoid this problem.(create rollback ...)
Make sure that while creating the new rollback segs u have considered the size thing in mind.
Regards,
Munish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
