Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Dammam
    Posts
    4

    Unhappy Unanswered: ORA-01925: maximum of 30 enabled roles exceeded

    While importing database tables I found this message:
    ORA-01925: maximum of 30 enabled roles exceeded


    I don't know why this message is coming.
    As we cannot change this parameter in parameter file.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    This is a parameter in your INITxxxx.ORA initialization file...

    MAX_ENABLED_ROLES = xxxx

    HTH
    Gregg

  3. #3
    Join Date
    Oct 2003
    Location
    Dammam
    Posts
    4
    In my initsidxxx.ora file the value is

    MAX_ENABLED_ROLES = 30


    Thanks

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Change the value from 30 to a higher value and "bump" the
    database.

    Gregg

  5. #5
    Join Date
    Oct 2003
    Location
    Dammam
    Posts
    4

    cannot edit that parameter

    When I am going to change the value through
    alter session
    it gives me error that this parameter is not editable.

    Ok.
    Thanks

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    This is not a dynamic parameter... You have to put it in the
    INITxxx.ora initialization file and restart the database

    Gregg

Posting Permissions

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