I am working with 8.1.5 on win2k adv server.
My v$option contains
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
Visual Information Retrieval FALSE
Export transportable tablespaces FALSE
Transparent Application Failover FALSE
Fast-Start Fault Recovery FALSE
Sample Scan FALSE
Duplexed backups FALSE
How to enable options those are FALSE.
P.S : I need INSTED-OF triggers enabling immediately
Thanks in adv
AFAIK You need to have Enterprise edition installed to use Instead-Of triggers.
By the looks of your options you have standard version installed.
it is 8i ee not std ..
Any more suggestions ?
Can you show the output from the following
SELECT * FROM v$version;
Kindly check the following
Oracle8i Release 22.214.171.124.0 - Production
PL/SQL Release 126.96.36.199.0 - Production
CORE Version 188.8.131.52.0 - Production
TNS for 32-bit Windows: Version 184.108.40.206.0 - Production
NLSRTL Version 220.127.116.11.0 - Production
Yep, it should read
Oracle8i Enterprise Edition Release 18.104.22.168.0 - Production
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.
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.