ORA-01555: snapshot too old: rollback segment number %n with name "%segname" too small.
Some useful tips can be found here: http://www.orafaq.com/wiki/ORA-01555
Questions tagged [ora-01555]
5 questions
9
votes
3 answers
Oracle - How does transaction, rollback segment and the undo_retention parameter work?
I'm no DBA, and I'm having a bit of a hard time understanding Oracle's transaction management process.
From what I understood by reading some reliable-looking pages on the Internet (most notably this AskTom note -- but don't bother with the…
Manur
- 8,436
- 2
- 27
- 29
6
votes
2 answers
Can I substitute savepoints for starting new transactions in Oracle?
Right now the process that we're using for inserting sets of records is something like this:
(and note that "set of records" means something like a person's record along with their addresses, phone numbers, or any other joined tables).
Start a…
Jason Baker
- 192,085
- 135
- 376
- 510
2
votes
2 answers
Oracle Materialized View Refresh fails with ORA-01555
I've a Materialized view set to refresh on demand:
CREATE MATERIALIZED VIEW XYZ
REFRESH COMPLETE ON DEMAND
AS
SELECT * FROM ABC WHERE LAST_UPD > SYSDATE-30;
When i run a procedure for refresh it fails every two days.
Refresh…
Pratheek Ponnuru
- 87
- 1
- 7
0
votes
1 answer
SQL----- Error when trying to export query results as CSV
I am running a large query (6 million records) which has a lot of INNER JOINS with other tables but when I am trying to export the query results on CSV I am getting the following results. I googled it for a while but could not get any…
tahmid53
- 1
- 1
0
votes
2 answers
Commit every 1000 rows
I am looking to do a commit every 1000 rows until all records are deleted, we have over a million records to be deleted.
Originally:
private static final String DELETE_OLD_REPORTS_FROM_REPORTING =
- "DELETE FROM A_REPORTING\n" +
- …
Paul B
- 11
- 1
- 1
- 3