We have a PL/SQL script that selects then purges data from a table row-by-row. We populated our Test environment with production data, ran it, and it worked fine. When we moved it to production and ran it against the same data, it failed with an ora-1555. We've set up a large rollback segment, and used the 'set transaction use rollback segment...' statement, to no avail. Has anyone else run into this? Any suggestions would be greatly appreciated. Thanks.
July 20, 2004 10:51 AM
July 21, 2004 10:58 AM