Rollback segments - database logging

Advertisement
November 30

Got a problem...
We are trying to move data from one database to another using: INSERT INTO table1 (SELECT a,b,c FROM [email protected]). The problem we are having is that the amount of data being moved with this in sert command is too great - we are getting an error indicating that our rollback segment is not large enough - ORA-01562: failed to extend rollback segment number 4.
Unfortunately, we are not going to be able to increase the size of the rollback segment any further than we already have. Is there a way to disable the database logging that occurs?
I tried using INSERT INTO table1 dbms_disable_logging (SELECT a,b,c FROM [email protected]), but noticed no difference - same error.
Any ideas?
Thank you,
Dan

Advertisement

Replay

We use select..into all the time in an unlogged mode for speed and rollback space reasons.
We replicate fifty million row tables with a minimal amount of rollback segment (<50MB).
In unlogged mode we can replicate 50 million rows in under forty minutes - that's smokin!
Oracle version 8 or greater introduced this concept. I am running 8.1.6.
You need to alter the table to disable logging and then perform the select into.
The table alter only takes seconds.
ALTER TABLE IDMDBO.DIM_PLANS NOLOGGING
Then do the select into and then turn logging back on (if so desired).
You can also disable logging at the table space level.
Keep in mind there are only a few database operations that can be performed unlogged and select..into is one of them.
There is currently no way to carte blanche disable transaction logging - hopefully this will be coming soon!
Cheers.
- Brendan Sullivan
null

View 4 Replies

Is "SET TRANSACTION USE ROLLBACK SEGMENT" only a hint

October 11

I have two users, one makes some inserts in a table. The other makes a select which visits many rows. I have a big rollback-segment. To ensure, both users use this rollback-segment I created a logon-trigger: CREATE OR REPLACE TRIGGER a_logon AFTER LO

View All Replies

Transaction table in rollback segments

November 30

hi guys, I have read the following, but am still having a little difficulty conceptualising. Would someone be kind enough to give me a very brief example? thanks For each rollback segment, Oracle maintains a transaction table--a list of all transacti

View All Replies

Oracle 9i - Rollback Segment Needs Recovery

November 30

I have been noticing for a few days that my UNDO tablespace has been growing in size for no apparent reason. My datafiles have only increased by 400 Meg over last 4 days, but UNDO tablespace has grown from 100 Meg - 5.6 Gig.... I decided to create a

View All Replies

Illegal rollback Segment operation in Automatic Undo mode

November 30

Hi, I use oracle database 9.2.0.1 and I try to install SCM repository but when I run ckcreate I saw an error message in the log file that Illegal rollback Segment operation in Automatic Undo mode because oracle 9.2 use automatic undo mode .So how can

View All Replies

ROLLBACK SEGMENTS OPERATION

November 30

Hello Everyone This is the first time I am a forum member and I'm figuring out how it works because I have a very big problem Look, I'm a support engineer and, as you know, the code of the application is not own by me. Three weeks ago I received a re

View All Replies

ORA-01534 rollback segment 'R1' does not exist

November 30

Greetings HELP!! We are using oracle 8.0.5 ... The database will not open because it says the system rollback segment does not exist. The database mounts but won't open. from the file system checks, the dbf file that contains the system rollback segm

View All Replies

Convert from Rollback segment(RBS)  to undotablespace

November 30

i have a database 9i and it using rollback segment and i would like to convert to undotablespace. question is there is anyway i can find it out what size undo i need to created base on the database right now i have it. the database is very critical i

View All Replies

Trying to understand rollback segments - offline tblspaces for backup

October 11

Using Oracle 8i, on Windows platform - The question - receive an error ORA-01556 when performing a sql "ALTER TABLESPACE MY_TBS_LT OFFLINE IMMEDIATE"; ============================================= First off I created a tablespace and table on an

View All Replies

Error rollback segment - urgent

November 30

hi i have created locally managed tablesspace and in init.ora file i have sent unto management as manual as our application needs to specify rollback segments when i created rollback segments and attached to a locally managed tablespace i am getting

View All Replies

Oracle error: Ora-01555 : snapshot too old: rollback segment number 1......

November 30

System Error: Unknown Database error (type qqdb_ResourceException) on WMS_WH1: Execute failed for SQL statement ............... error from database is: ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small... Any

View All Replies

Creating rollback segments

November 30

I would like to know how to create the perfect rollback segments. I currently have a database that is up and running, but I feel that the rollback segments, are not running at there best. I know that the minextents should be set to 20 extents, inital

View All Replies

Different rollback segment used. why?

November 30

Hi. I am trying to use rollback segment RB6 in a delete process in a stored procedure using SET TRANSACTION USE ROLLBACK SEGMENT RB6; However, when the procedure is called and performed, an error is thrown: ORA-01562: failed to extend rollback segmen

View All Replies

Oracle9i How to convert from undo tables to rollback segments

November 30

Hi, Anyone try before converting from UNDO management to using rollback segment....What are the procedures for the conversion... Thank You...Hi, Follow these steps to convert from Auto UNDO to Rollback Segs.... 1. With the database opened, create a r

View All Replies

Rollback segment corruption on oracle 7.3

November 30

We have an oracle 7.3 database on solaris(sparc) 2.6. In the midddle of the transactions, the following error message occured: ORA 1578 Data block corrupted(file #2, block#8274) ORA-1110 Datafile 2:'/user1/oradb/rbstbl.dbf' (this datafile corresponds

View All Replies

ROLLBACK SEGMENT VERSION 7.3

November 30

We have an oracle 7.3 database on solaris(sparc) 2.6. In the midddle of the transactions, the following error message occured: ORA 1578 Data block corrupted(file #2, block#8274) ORA-1110 Datafile 2:'/user1/oradb/rbstbl.dbf' (this datafile corresponds

View All Replies

Why Oracle10g uses System Rollback Segment....????

November 30

Hi , Just a wonder....!!!! Why Oracle10g uses System Rollback Segment....and not System undo tablespace... since rollback segment as a method to rollback transactions has been depreciated.....????? Thanks..... SimSystem Rollback Segment is reserved f

View All Replies

Relationship bet. SPfile and Rollback Segments

November 30

Hi there, I'm wondering if there are any relationship between the above two. Since I changed SPfile and i don't remember what, the rollback segments status are changed to OFFLINE and i created a new rollback segment name (RB1) and i have to manually

View All Replies

When start rollback segment not online

November 30

hi to all, i have a one problem regarding rollback segment. i have created a new database & give five rollback segment, but when i start it is offline it will not start as online. [email protected] Pradip Mistry, nullHello Tina, If the overflow in a

View All Replies

Rollback segment  problem during import

October 11

Hello experts, please help. I have the following error when importing table data to my Oracle 8.1.7 database. IMP-00058: ORACLE error 1562 encountered ORA-01562: failed to extend rollback segment number 16 ORA-01237: cannot extend datafile 3 kind reg

View All Replies

Tags:

  1. 4.4.2verssion changer app
  2. BExGetData
  3. SAP fm view maintian
  4. in report manager scroll issues in ssrs
  5. 7PBZ
  6. solar7s3
  7. throughoutrpq
  8. новости челябинск мир 74
  9. ordinaryphq
  10. clockty7
Copyrights 2019 Fcffair BigData Resource, All rights reserved