RE: Still: problem with startup database trigger

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Mon, 30 Oct 2000 23:24:37 -0000
Message-Id: <10665.120626@fatcity.com>

Hi Helmut,

Not commenting on creating the trigger as sys, a synonym for dbms_shared_pool does not exist by default.

Either create a synonym for it or use "sys.dbms_shared_pool.keep (...."

Hope this helps

Regards,
Bruce

-----Original Message-----
From: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com] Sent: Tuesday, 31 October 2000 10:12
To: Multiple recipients of list ORACLE-L Subject: Still: problem with startup database trigger

Hi!

Thanks for all the input so far, but I still can't get that startup database trigger to work:

CREATE OR REPLACE TRIGGER startup_db
after startup on database
begin

    dbms_shared_pool.keep ('SYS.STANDARD','P');     dbms_shared_pool.keep ('SYS.DBMS_STANDARD','P'); end;

When compiling that trogger in TOAD, I get: PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared

I want to create the trigger as the SYS user and I explicitly assigned ADMINISTER DATABASE TRIGGER system privilege to SYS.

This is 8.1.6 on Win2k.

Any ideas?

Thanks,
Helmut

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 30 2000 - 17:24:37 CST