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

Thread: enabling options..

  1. #1
    Join Date
    Nov 2002
    Posts
    115

    enabling options..

    hi freinds,

    I am working with 8.1.5 on win2k adv server.

    My v$option contains

    PARAMETER Value
    -------------------------------------------------
    Partitioning FALSE
    Objects TRUE
    Parallel Server FALSE
    Advanced replication FALSE
    Bit-mapped indexes FALSE
    Connection multiplexing TRUE
    Connection pooling TRUE
    Database queuing FALSE
    Incremental backup and recovery FALSE
    Instead-of triggers FALSE
    Parallel backup and recovery FALSE
    Parallel execution FALSE
    Parallel load TRUE
    Point-in-time tablespace recovery FALSE
    Fine-grained access control FALSE
    N-Tier authentication/authorization FALSE
    Function-based indexes FALSE
    Plan Stability FALSE
    Online Index Build FALSE
    Coalesce Index FALSE
    Managed Standby FALSE
    Materialized view rewrite FALSE
    Materialized view warehouse refresh FALSE
    Database resource manager FALSE
    Spatial FALSE
    Visual Information Retrieval FALSE
    Export transportable tablespaces FALSE
    Transparent Application Failover FALSE
    Fast-Start Fault Recovery FALSE
    Sample Scan FALSE
    Duplexed backups FALSE
    Java
    FALSE



    How to enable options those are FALSE.

    P.S : I need INSTED-OF triggers enabling immediately

    Thanks in adv
    Prasad

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    AFAIK You need to have Enterprise edition installed to use Instead-Of triggers.

    By the looks of your options you have standard version installed.

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Nov 2002
    Posts
    115
    jovery,

    it is 8i ee not std ..

    Any more suggestions ?
    Prasad

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Can you show the output from the following

    Code:
    SELECT * FROM v$version;
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Nov 2002
    Posts
    115
    javery,

    Kindly check the following

    Oracle8i Release 8.1.5.0.0 - Production
    PL/SQL Release 8.1.5.0.0 - Production
    CORE Version 8.1.5.0.0 - Production
    TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
    NLSRTL Version 3.4.0.0.0 - Production
    Prasad

  6. #6
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Yep, it should read
    Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  7. #7
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    As Tomazz said (and I initally noted) you are using the standard version NOT enterprise edition.

    You will need to upgrade to EE to take advantage of the features your want.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  8. #8
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104
    Ya..that's right. You need to upgrade to EE and here u will have more options than the standard one. Have seen most of the features are enabled in EE version than standard but database size requirement could be a bottleneck.

Posting Permissions

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


Click Here to Expand Forum to Full Width