No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1323
Act. users last 24h3
Act. users last hour0
Registered user hits last week79
Registered user hits last month345
Comment details
Date 16-JAN-07
Type Bug
User Naser Bodair
Message SQL> @/app/oracle/plato.sql
This script may be run as any user.
It is recommended to run this script in SQL*Plus (due to the substitution var's)
================================================================================== VERIFYING PREREQUISITES ... ==================================================================================
-- You need to run as SYS:
create or replace view SYS.PLATO$GDP$KSPPI AS
SELECT a.ksppinm as parameter, a.ksppdesc as description,
b.ksppstvl as session_value, c.ksppstvl as
instance_value,
c.ksppstdf as is_default
FROM x$ksppi a, x$ksppcv b, x$ksppsv c
WHERE a.indx = b.indx
AND a.indx = c.indx;

create or replace view SYS.PLATO$GDP$KCCDI AS
select dimlm from sys.x$kccdi;

-- After doing all this, run this setup script again as user
SYS

================================================================================== PREREQUISITES NOT OK, FURTHER INSTRUCTIONS ARE DISPLAYED
ABOVE ==
================================================================================
DECLARE
*
ERROR at line 1:
ORA-20999: Follow the instructions above, then run the setup script
again.
ORA-06512: at line 214


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options