Results 1 to 8 of 8

Thread: Error ORA-00406

  1. #1
    Join Date
    Jan 2003
    Posts
    6

    Unanswered: Error ORA-00406

    Hello again everyone..

    I've got a database setup and foiund that after I did some testing I don't need a specific column, but also found that I can't drop the column..

    SQL> alter table tracking drop column test;
    alter table tracking drop column test
    *
    ERROR at line 1:
    ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater


    SQL>

    And I'm kinda confused.. any help would be great....

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Error ORA-00406

    You need to be on at least Oracle 8.1 to drop columns. If your version of Orace IS 8.1 or higher, then it has the COMPATIBLE parameter set to a lower value - this would be done deliberately while evaluating a new Oracle version to ensure no new features were accidentally used.

  3. #3
    Join Date
    Jan 2003
    Posts
    6

    Re: Error ORA-00406

    Originally posted by andrewst
    You need to be on at least Oracle 8.1 to drop columns. If your version of Orace IS 8.1 or higher, then it has the COMPATIBLE parameter set to a lower value - this would be done deliberately while evaluating a new Oracle version to ensure no new features were accidentally used.
    As far as I know we are using 8.1.7.0.1

    So is there ANY other way to get rid of this column?

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Error ORA-00406

    Originally posted by Norman
    As far as I know we are using 8.1.7.0.1

    So is there ANY other way to get rid of this column?
    Well, you could just change the COMPATBLE parameter to 8.1.7.0.1 and then it will work.

    If that isn't permitted, then you would have to do it the hard way:

    CREATE TABLE new_tracking AS SELECT ... FROM tracking;

    DROP TABLE tracking;

    RENAME new_tracking TO tracking;

    (Then add back missing indexes, constraints, triggers, ...)

  5. #5
    Join Date
    Jan 2003
    Posts
    6

    Re: Error ORA-00406

    Originally posted by andrewst
    Well, you could just change the COMPATBLE parameter to 8.1.7.0.1 and then it will work.
    Hate tos ound so clueless, but oracle is a new beast for me.

    Can I change it using the Alter Session and/or some other set command?

    Thanks

  6. #6
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Error ORA-00406

    Originally posted by Norman
    Hate tos ound so clueless, but oracle is a new beast for me.

    Can I change it using the Alter Session and/or some other set command?

    Thanks
    You could use ALTER SYSTEM, if you have sufficient privileges. If you are not the DBA, I suggest you contact him/her.

  7. #7
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279

    Re: Error ORA-00406

    Originally posted by andrewst
    You could use ALTER SYSTEM, if you have sufficient privileges. If you are not the DBA, I suggest you contact him/her.
    Ah, no disrespect intended, but you can't modify compatible via ALTER SESSION or ALTER SYSTEM. Your only recourse is to change the init.ora and bounce the instance.

    Code:
    SQL> l
      1  select name, issys_modifiable, isses_modifiable, value from v$parameter
      2* where upper(name) like 'COMPAT%'
    SQL> /
    
    NAME                           ISSYS_MOD ISSES VALUE
    ------------------------------ --------- ----- --------------------
    compatible                     FALSE     FALSE 8.1.0

  8. #8
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Error ORA-00406

    Originally posted by marist89
    Ah, no disrespect intended, but you can't modify compatible via ALTER SESSION or ALTER SYSTEM. Your only recourse is to change the init.ora and bounce the instance.
    Thanks for correcting me - I was careless in checking the documentation.

Posting Permissions

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