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?
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…
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