enabling options..

Printable View

08-26-2003, 06:47 AM
prasadvd

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
08-26-2003, 06:53 AM
jovery

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
08-26-2003, 07:10 AM
prasadvd

jovery,

it is 8i ee not std ..

Any more suggestions ?
08-26-2003, 07:22 AM
jovery

Can you show the output from the following

Code:

SELECT * FROM v$version;
08-26-2003, 07:27 AM
prasadvd

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
08-26-2003, 07:42 AM
TomazZ

Yep, it should read
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
08-26-2003, 08:04 AM
jovery

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
08-26-2003, 09:01 AM
sudheer_nm

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.