-
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
-
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!
-
jovery,
it is 8i ee not std ..
Any more suggestions ?
Prasad
-
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!
-
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
-
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
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|