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

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

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

    quote:
    --------------------------------------------------------------------------------
    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.

  2. #2
    Join Date
    Jan 2004
    Posts
    9

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

    Originally posted by jomjohn
    Re: IMP-00003: ORACLE error 439 .......Pls more help needed

    quote:
    --------------------------------------------------------------------------------
    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.
    Hi


    this file is in ur
    Drive:\oracle\admin\urdbname\pfile\init.ora or initurdbname.ora

    plis if take care to make changes in this file bcose it's very important file.
    to check effect u need to shut database and start it.

    by take care

  3. #3
    Join Date
    Jan 2004
    Posts
    7

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

    Originally posted by salim_dba@yahoo
    Hi


    this file is in ur
    Drive:\oracle\admin\urdbname\pfile\init.ora or initurdbname.ora

    plis if take care to make changes in this file bcose it's very important file.
    to check effect u need to shut database and start it.

    by take care
    Sir

    Thanks for your help and i will try it out and if any problem
    i will contact you

    Bye and take care

    jom.

  4. #4
    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. These files are located in the "ORACLE_HOME/dbs" directory.
    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
  •