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

Thread: ORA-00406 COMPATIBLE parameter needs to be string or greater

  1. 11-05-2003, 01:09 AM #1
    zulu99
    zulu99 is offline Member
    Join Date
    Dec 2002
    Posts
    110

    ORA-00406 COMPATIBLE parameter needs to be string or greater

    Hi All

    As per the error docs

    Cause: The value of the COMPATIBLE initialization parameter is not high enough to allow the operation. Allowing the command would make the database incompatible with the release specified by the current COMPATIBLE parameter.

    Action: Shut down and restart with a higher compatibility setting.


    How do i do this , do i have to do this in init.ora file setting parameter


    Rgrds
    sushant
    Reply With Quote Reply With Quote
  2. 11-05-2003, 06:35 AM #2
    fraze
    fraze is offline Senior Member
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    in SQL Plus do a show parameter compatible to get your current setting. Its an init.ora parameter so change it in the init file ( e.g. compatible = 9.2.0.3) and bounce the DB
    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