Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sys.dbms_shared_pool

sys.dbms_shared_pool

From: dfp1 <dfp1_at_istar.ca>
Date: Tue, 20 Apr 1999 16:12:22 -0400
Message-ID: <7fin1o$73h$1@demon.uunet.ca> 





Hi,



I have 2 databases TEST and PROD. PROD was created with the same physical
characteristics as TEST and a full export from TEST was imported into PROD.



However I cannot find the package DBMS_SHARED_POOL package which exists in
the SYS schema of TEST under packages, in PROD.



At what point in database creation does this package get loaded, or is it
accomplished by a script such as CATPROC? Wouldn't the full import have
brought it over anyway? How can I laod it now?



Thanks,


Dinesh


Received on Tue Apr 20 1999 - 15:12:22 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US