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
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 12-DEC-06
Type Comment
User rachid el hilali
Message when i try to execute plato i got the following message:
thak you for your help

SQL> @plato_49_10g.sql;

-- 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;

-- You need to run as SYS:

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

-- Creating global temporary table PLATO$GDP_TEMP