ROLLBACK SEGMENT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ROLLBACK SEGMENT

  1. #1
    Join Date
    Nov 2000
    Posts
    178
    Hello,

    I created a private rollback segment with this synthax and connected as myself/user with DBA privileges:

    CREATE PRIVATE ROLLBACK SEGMENT...

    When I queried the database the owner of the new RBS is system. Can anybody please tell my why?

    Ac

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    The owner of a rollback segment is always SYS no matter who creates it.

    David Knight
    OCP DBA 8i, 9i, 10g

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