| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: sys.dbms_shared_pool
Dinesh,
You are right, DBMS_... packages are usually created as part of the
catalog - just after the CREATE DATABASE. As they belong to SYS, they
are not exported by a full export. To install them afterwards, you must
go to the $ORACLE_HOME/rdbms/admin directory - or its NT equivalent
(this is where catalog.sql is located). For all the dbmsxxx packages you
have two files, a dbmsxxx.sql which is the public part (package) and a
dbmsxxx.plb which is the private part (package body), usually 'wrapped'
- ie unlegible hexadecimal code. You just have to logon as SYS (sqlplus
or Server Manager (INTERNAL)) and run both scripts.
--
Regards,
Stéphane Faroult
Oriole Corporation
 |
 |