Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lots of Rollback!

Status
Not open for further replies.
pdalberth

pdalberth

IS-IT--Management
Nov 22, 2000
13
US
I am populating an existing but empty table using an insert into (target table name) select * from (source table name). The source table contains about 106 MB of data. The transaction has been running for several hours and has generated more than 400 MB of rollback. Is this expected behavior?

I wish Oracle would add an "unrecoverable" clause to some SQL statements; its rollback mechanisms generate lots of pain and suffering.
 
Sort by date Sort by votes
Is this not possible? create table table_name unrecoverable as select * from other_table?

The unrecoverable goes after the storage clause of the table. This is allowed in 7.3.4 which version are you running?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
720
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
286
Livia8
Livia8
torturedmind
  • Locked
  • Question
Week of the year
Replies
0
Views
141
torturedmind
torturedmind
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
277
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Modify columns - parts of virtual column 2
Replies
8
Views
1K
carp
carp

Part and Inventory Search

Sponsor

Back
Top