-
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
-
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
-
jovery,
it is 8i ee not std ..
Any more suggestions ?
-
Can you show the output from the following
Code:
SELECT * FROM v$version;
-
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
-
Yep, it should read
Oracle8i Enterprise Edition Release 8.1.5.0.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.
Regards
-
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.