Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: IMP-00003: ORACLE error 439 ......pls more help needed

    Hi,
    I have read that on Oracle 8.1.7 standard edition it is possible to create a function based index by
    setting
    query_rewrite_enabled = true
    query_rewrite_integrity = trusted
    compatible = 8.1.0 or greater

    Will this setting work ?.If it works ,i am unsure about in which file i have to make these changes
    and the location of that file.

    Can any one give a solution to this problem
    Last edited by jomjohn; 01-07-04 at 02:30.

  2. #2
    Join Date
    Jan 2004
    Posts
    24

    Re: IMP-00003: ORACLE error 439 encountered

    Originally posted by jomjohn
    Hi,
    I have read that on Oracle 8.1.7 standard edition it is possible to create a function based index by
    setting
    query_rewrite_enabled = true
    query_rewrite_integrity = trusted
    compatible = 8.1.0 or greater

    Will this setting work ?.If it works ,i am unsure about in which file i have to make these changes
    and the location of that file.

    Can any one give a solution to this problem

    Function based index is one of the new features in Oracle 8i.The following parameters must be set in your parameter file: QUERY_REWRITE_INTEGRITY = TRUSTED
    QUERY_REWRITE_ENABLED = TRUE
    COMPATIBLE = 8.1.0.0.0 (or higher)
    If you want any further information check out this site
    http://www.dbasupport.com/oracle/ora8/fbi.shtml


    Bye
    Uma

  3. #3
    Join Date
    Jan 2004
    Posts
    7

    Re: IMP-00003: ORACLE error 439 .......Pls more help needed

    Originally posted by movva_uma
    Function based index is one of the new features in Oracle 8i.The following parameters must be set in your parameter file: QUERY_REWRITE_INTEGRITY = TRUSTED
    QUERY_REWRITE_ENABLED = TRUE
    COMPATIBLE = 8.1.0.0.0 (or higher)
    If you want any further information check out this site
    http://www.dbasupport.com/oracle/ora8/fbi.shtml


    Bye
    Uma
    Thanks a lot for your replay

    But i was not able to locate init.ora in my oracle directory
    i am using the oracle 8.1.7 standard one and can u please say me
    the default location where i can place this file and make this entries changes

    Bye
    jom.
    Last edited by jomjohn; 01-07-04 at 02:29.

  4. #4
    Join Date
    Jan 2004
    Posts
    24

    Re: IMP-00003: ORACLE error 439 .......Pls more help needed

    Originally posted by jomjohn

    Hi John,

    By default,a pointer to the init.ora file in ur OFA compliant
    admin/sid/pfile administrative directory (where sid is to be
    replaced with ur database name) is located in $ORACLE_HOME/dbs
    on a UNIX m/c.In WINDOWS the actual init.ora file is located in
    the %ORACLE_HOME%\database directory.
    I hope that this information will help u in finding
    ur database init.ora location


    Regards
    uma.movva


    Thanks a lot for your replay

    But i was not able to locate init.ora in my oracle directory
    i am using the oracle 8.1.7 standard one and can u please say me
    the default location where i can place this file and make this entries changes

    Bye
    jom.

  5. #5
    Join Date
    Jan 2004
    Posts
    7

    Re: IMP-00003: ORACLE error 439 .......Pls more help needed

    Originally posted by movva_uma

    Sir/Madam,

    Thanks a lot for your great help and will work on this and try for a result if any problem arise i will report it to you

    Bye
    jomjohn.

  6. #6
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    The "init.ora" file is a template file that is provided with Oracle Software. This template file is then copied to the "init<SID>.ora" file. The "init<ID>.ora" file will be used to start your database. These files are located in the "ORACLE_HOME/dbs" directory.
    SATHISH .

  7. #7
    Join Date
    Jan 2004
    Posts
    7

    Can any body say how to disable the function-based indexes

    hi,

    Can any body say me how to disable the function-based indexes in
    oracle 8.1.7 entrprise edition.

    regards
    jom.

  8. #8
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    You can make use of 'alter index ... disable'. This clause enables you to disable the use of a function-based index.

    Afterward you can either rebuild the index or specify another ALTER INDEX statement with the ENABLE keyword.
    SATHISH .

Posting Permissions

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