Stored Procedures/Functions

[Easaw T Mathew]

Dear Gurus

How would one monitor when and who may be executing a stored
procedure/package etc at any one point in time. Similar to table locks
although thats more straightforward to monitor.

Pls advise

Thanks in Advance

IMPORTANT: This e-mail (including all attachments) is confidential and
may be privileged. It may be read, copied and used only by the intended
recipients, and must not be re-transmitted in any form without our consent.
If you have received it in error, please contact us immediately by return 
e-mail.  Please then delete it and do not disclose its contents to any
other person.

Security and reliability of email is not guaranteed. Communications should
be verified from a mailed or faxed copy.  All emails to anyone @vitol.com
are communications to the firm and are not private or confidential to any
named individual.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Easaw T Mathew
  INET: [EMAIL PROTECTED]

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: [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).

ORA-02270 error during import

[Easaw T Mathew]

hi

Error during import: ORA-02270: no matching unique or primary key for this
column-list

i am in the process of migrating my oracle databases from dg/ux to solaris8
OS. at the same time, i am taking the opportunity to resize the tables,
indexes to cater for growth in the near future. 

to do this, i hv created fresh the new database with improved settings
(given the luxury of disk space we hv now), created the tables and indexes
with new sizings, moved the export over to the new machine and reimported
it. the export was a full export. 

on import, i get the above error which means that it cant create a foreign
key constraint becos the primary key constraint for the table has not been
created. this is the case for quite a few of the tables but most of the 400
or so tables were fine.

why should this occur and under what circumstances wld this occur? and how
do i fix this?

almost all the documentation i hv checked including oracle web sites do not
offer a solution and I am not sure the best way forward without a lot of
workaround being done which may not be ideal.

wld any Oracle gurus be kind enough offer any ideas or thoughts on this
except that the export/import utility is probably buggy.

many thanx
Easaw T Mathew
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Easaw T Mathew
  INET: [EMAIL PROTECTED]

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: [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).