Questions tagged [rollbacksegments]
5 questions
1
vote
4 answers
drop/truncate and rollback segment
I know that drop removes the data as well as the table structure whereas truncate retains table structure.
Does drop/truncate write to roll back segment ?

user319280
- 757
- 1
- 8
- 14
0
votes
0 answers
Dotnet Nuke Files automatically getting Rollback
The template files like ( Home.ascx) inside Xcillion are getting rolled back to specific date in the Server. What could be the issue?

Sandhya
- 1
0
votes
3 answers
Oracle Rollback Segments and ADO.NET
I am using an ancient version of Oracle (8.something) and my ADO.NET application needs to do some fairly large transactions. Large enough to not fin in our small rollback segments. Now we have a large rollback segment as well but it is not used by…

Tamas Czinege
- 118,853
- 40
- 150
- 176
0
votes
0 answers
SQL Server 2008 : Error handling in SP
I have a stored procedure that has 2 flaws:
If there is an error in the stored procedure, it keeps executing. I want the stored procedure to stop immediately once there is any error found.
There is an error log table for this stored procedure, I…

user3294322
- 97
- 9
0
votes
2 answers
Would splitting a query by an indexed ID field avoid ORA-01555: snapshot too old error?
I have some queries of the form:
select * from MAIN.MY_TABLE
where ID in (select ID from OTHER.OTHER_TABLE where type = 'BANANA');
Where ID is indexed on MAIN.MYTABLE, but not indexed on OTHER.OTHER_TABLE
Recently these have been erroring with…

dwjohnston
- 11,163
- 32
- 99
- 194