Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    78

    Unanswered: COMPATIBLE parameter needs to be 8.1.6.0.0

    Using DDL Triggers i want to track all changes to database .
    Whatever changes to database new entries to the stats$ddl_log table.
    I got the below error when executing the system level triggers(Our database 8i(8.1.6) enterprise edition)


    create table
    perfstat.stats$ddl_log
    (
    user_name varchar2(30),
    ddl_date date,
    ddl_type varchar2(30),
    object_type varchar2(18),
    owner varchar2(30),
    object_name varchar2(128)
    )
    tablespace perfstat
    ;




    SQL> create or replace trigger
    2 DDLTrigger
    3 AFTER DDL ON DATABASE
    4 BEGIN
    5 insert into
    6 perfstat.stats$ddl_log
    7 (
    8 user_name,
    9 ddl_date,
    10 ddl_type,
    11 object_type,
    12 owner,
    13 object_name
    14 )
    15 VALUES
    16 (
    17 ora_login_user,
    18 sysdate,
    19 ora_sysevent,
    20 ora_dict_obj_type,
    21 ora_dict_obj_owner,
    22 ora_dict_obj_name
    23 );
    24 END;
    25 /
    AFTER DDL ON DATABASE
    *
    ERROR at line 3:
    ORA-00406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater

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

    Re: COMPATIBLE parameter needs to be 8.1.6.0.0

    Do this:

    SQL> select value
    2 from v$parameter
    3 where name ='compatible'
    4 /

    It will obviously show a value LOWER than 8.1.6.0.0.

    To use the feature you want to use you need to set the COMPATIBLE parameter to 8.1.6.0.0 or higher (as the error message said!)
    This is something you must take up with your DBA.
    The reason it currently has a lower value than your database version is probably that it was set that way when the database was originally upgraded, to prevent people from using new features in case the upgrade had to be backed out. That must have been a long time ago now, so it shouldn't be an issue to set it to 8.1.6.0.0

Posting Permissions

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