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

Thread: tablespace for the rollback segmente!

  1. #1
    Join Date
    Jul 2000
    Posts
    119
    Which of the following commands would be used to dedicate a rollback segment to the data_tbs tablespace?
    Choice 1 alter rollback segment rs01 set tablespace = 'DATA_TBS';
    Choice 2 alter tablespace data_tbs set rollback_segment = 'RS01';
    Choice 3 alter system set tablespace rollback segment = 'RS01' where tablespace_name = 'DATA_TBS';
    Choice 4 alter database set tablespace rollback segment = 'RS01' where tablespace_name = "DATA_TBS';
    Choice 5 None of the above.

    any clues ?
    this q was one on the test .!!!

  2. #2
    Join Date
    Dec 2000
    Posts
    11

    Thumbs up

    Hi,

    my opinion choice 5.

    Marius

  3. #3
    Join Date
    Nov 2000
    Posts
    205
    so would my answer. The 3 and 4 look so way out wrong, since we never update using where (DML) for dictionary info.

    Nirasha

  4. #4
    Join Date
    Dec 2000
    Posts
    14

    My opinion is 5

    Subbarao Manchikanti

  5. #5
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234
    Answer 5

    IMHO
    You have to bring offline, drop and (re)create a rollback segment if you want to relocate it to a different tablespace.

    (I don't see the point in doing it but.....)

    tycho


  6. #6
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    seems to me that oracle is running out of questions for their ocp exam this is one of the dumbest questions i have seen anybody with even a years of experience could tell you that choice 5 is correct.DESPERATELY hope that oracle improves its question bank to include sensible questions

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