Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    37

    Unanswered: why does the create fail in this case...

    CREATE ROLLBACK SEGMENT rbs01
    TABLESPACE rbs
    STORAGE (
    INITIAL 100K
    NEXT 100K
    MINIEXTENTS 1
    MAXEXTENTS 100
    OPTIMAL 2000K);

  2. #2
    Join Date
    Feb 2004
    Posts
    45

    Re: why does the create fail in this case...

    What is the text of the error message you are seeing or what makes you think it's failing ?
    What version of oracle ?
    What platform ?

    Originally posted by chiranjib_s
    CREATE ROLLBACK SEGMENT rbs01
    TABLESPACE rbs
    STORAGE (
    INITIAL 100K
    NEXT 100K
    MINIEXTENTS 1
    MAXEXTENTS 100
    OPTIMAL 2000K);
    It was working just 5 minutes ago - I promise !

  3. #3
    Join Date
    Jan 2004
    Posts
    370
    MINEXTENTS 2 for rollback segments

Posting Permissions

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