Thanks Suzy, Waleed, John, Richard, Connor, Jonathan, for your help. Out of shape on sundays :-)
TKS -----Original Message----- Vordos Sent: Sunday, February 23, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Don't think you need to use execute immediate. Try this (should be run as SYS): CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA AFTER STARTUP ON DATABASE BEGIN dbms_shared_pool.keep('DBMS_ALERT'); dbms_shared_pool.keep('DBMS_DDL'); dbms_shared_pool.keep('DBMS_DESCRIBE'); dbms_shared_pool.keep('DBMS_LOCK'); dbms_shared_pool.keep('DBMS_OUTPUT'); dbms_shared_pool.keep('DBMS_PIPE'); dbms_shared_pool.keep('DBMS_SESSION'); dbms_shared_pool.keep('DBMS_SHARED_POOL'); dbms_shared_pool.keep('DBMS_STANDARD'); dbms_shared_pool.keep('DBMS_UTILITY'); dbms_shared_pool.keep('STANDARD'); dbms_shared_pool.keep('BUSCA_SECUENCIA'); END; / > "Ramon E. Estevez" wrote: > > Sorry, new DB and hadn't execute the Dbmspool.sql script. > > CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA > AFTER STARTUP ON DATABASE > BEGIN > exec immediate dbms_shared_pool.keep('DBMS_ALERT'); > exec immediate dbms_shared_pool.keep('DBMS_DDL'); > exec immediate dbms_shared_pool.keep('DBMS_DESCRIBE'); > exec immediate dbms_shared_pool.keep('DBMS_LOCK'); > exec immediate dbms_shared_pool.keep('DBMS_OUTPUT'); > exec immediate dbms_shared_pool.keep('DBMS_PIPE'); > exec immediate dbms_shared_pool.keep('DBMS_SESSION'); > exec immediate dbms_shared_pool.keep('DBMS_SHARED_POOL'); > exec immediate dbms_shared_pool.keep('DBMS_STANDARD'); > exec immediate dbms_shared_pool.keep('DBMS_UTILITY'); > exec immediate dbms_shared_pool.keep('STANDARD'); > exec immediate dbms_shared_pool.keep('BUSCA_SECUENCIA'); > END; > > I am getting this error, tried with users SYS and SYSTEM > > 12/11 PLS-00103: Encountered the symbol "DBMS_SHARED_POOL" when > expecting one of the following: > := . ( @ % ; > tia > > > Ramon E. Estevez > [EMAIL PROTECTED] > 809-565-3121 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).