Post reply

Importing error- Oracle table to SQL Server 2000

  • July 27, 2005 at 8:11 am

    #186860

    Hello All

    I've been importing oracle table into SQL Server using the DTS Import/Export Wizard but can across  this error message.

    Error message: Error at Source for Row number 596787.Error encountered so far in this task:1 [Microsoft][ODBC driver for Oracle][Oracle]ORA-01555:snapshot too old:rollback segment number 15 with name "R15" too small.

    Thanks for any advise to handle this issue.

    Ryan

     

  • July 27, 2005 at 9:05 am

    #577593

    Hi Ryan

    I'm no Oracle expert but the first thing I thought of was that you may have an uncommitted rollback segment prohibiting the import.

    Here's what otn has to say:

    Before a transaction that modifies data is committed, the following has occurred:

    • Oracle has generated rollback segment records in buffers in the SGA that store rollback segment data. The rollback information contains the old data values changed by the SQL statements of the transaction.

    Try to force a commit by shutting down the instance with TRANSACTION specified, STARTUP the instance again and see if the data is committed.

    Once again I'm no Oracle guru and please check with your ora dba before shutting down the instance. If you find the cause pls let me know.

    Cheers

    Max

  • July 27, 2005 at 9:14 am

    #577600

    The other thing you can try is to drop the rollback segment: DROP ROLLBACK SEGMENT R15;

    According to OTN you can only drop it if it's offline (check the data dictionary view: DBA_ROLLBACK_SEGS).

    Once again pls check with your ora dba as I'm not the one who'll be in trouble if something goes wrong.

    Max

  • July 28, 2005 at 2:48 am

    #577797

    H!!,

      Please check weather any other process are running in the user of oracle from which you are trying to port the data..

     

    vinod(DBA)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply