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

Thread: ROLLBACK SEGMENT

  1. 06-08-2001, 05:36 AM #1
    ac
    ac is offline Member
    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
    Reply With Quote Reply With Quote
  2. 06-08-2001, 06:33 AM #2
    dknight
    dknight is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width