regarding ORA-01562
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: regarding ORA-01562

  1. #1
    Join Date
    Oct 2000
    Posts
    21

    Smile

    I have a query:
    u get ora-1562 error. u checked v$rollstat table and found
    that a rollback segment has status 'FULL'. now, if u make that roll back
    segment offline, and then online, the status 'FULL' will be removed. My
    question is, during the course of this period, what will happen for those
    uncommitted transactions residing in this rollback segment?
    Pao de dabba
    B'ham

  2. #2
    Join Date
    Aug 2000
    Posts
    236
    Pao,

    Oracle will NOT take the RBS offline until the transactions complete. They either have to be comitted or rolled back. Only then they are taken offline.

    Nizar

  3. #3
    Join Date
    Oct 2000
    Posts
    21
    thax nizar
    Pao de dabba
    B'ham

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width