They are both processing the same data, the same way.
-----Original Message-----
Sent: Tuesday, July 22, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Ron
I'm guessing that one of the loads receives the ORA-01555 and the
other doesn't. Does the load commit occasionally? There are some pretty
good papers on Metalink for this error.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, July 22, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L
Help!
I have a production and a test database, both with 3000mg RBS
tablespaces with two datafiles. Both have db_block_buffers set at 1000.
The only difference is the production db has 7 rollback segments and the
test db has 8. The rollback segments are sized at 50mg each on both
databases.
The problem is, at night when the batch load is running (by itself), the
load fails with a ORA-01555. The data is the same on both loads.
Nothing else is going on in the database during the load.
Any ideas?
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
