Re: DBA_PROCEDURES / DBA_TRIGGERS

On 26 Jun., 21:27, sybra...@xxxxxxxxx wrote:
On Thu, 26 Jun 2008 09:33:02 -0700 (PDT), bierwaer...@xxxxxxxxxxxxxx
wrote:

I'm asking this because we are preparing a script to move all objects
from one schema to another schema that contains already some objects
whereas we don't want to overwrite newer objects in the new schema
with older stuff from the old schema.

Why don't you use expdp/impdp?
Can export anything, can import anything.
Why write a script when the functionality exists?

--
Sybrand Bakker
Senior Oracle DBA

We're aware of exp/imp functionality...

Our problem is: We are updating an application that has been extended
by my predecessor but he did not document which changes and/or
addition he had made.
So I was trying to find out which triggers, procs, packages, synonyms,
etc. have been created by him.
I did that by comparing all entries in DBA_TRIGGERS in the new schema
to the entries in DBA_TRIGGERS in the old schema:
SELECT trigger_name from DBA_TRIGGERS where owner ='old_schema' minus
SELECT trigger_name from DBA_TRIGGERS where owner ='new_schema';
That gave a list of triggers that we had to examine, whether they had
to be moved to the new schema.
We did that for all object types, but then we found the problem with
DBA_PROCEDURES showing only valid procs.

D.
.

Relevant Pages

  • Not able to import the schema in ADAM in one go
    ... ADAM through LDIFDE command. ... entries. ... The schema is loaded comfortably for the 265 ... I cut these two entries and load them exclusively from a ...
    (microsoft.public.windows.server.active_directory)
  • Re: adding 2003 to 2000 domain , ERROR: Failed to transfer the schema FSMO role: 52
    ... In this article they mention some entries but there are ... >of the Schema Admins? ... Admins and Schema ... >> Adprep was unable to upgrade the schema on the schema ...
    (microsoft.public.win2000.active_directory)
  • Re: DBA_PROCEDURES / DBA_TRIGGERS
    ... with older stuff from the old schema. ... So I was trying to find out which triggers, procs, packages, synonyms, ... DBA_PROCEDURES showing only valid procs. ... Still, just out of curiosity, does anyone have a clue why DBA_TRIGGERS ...
    (comp.databases.oracle.server)
  • Re: unique record
    ... there are ways to validate the entries in all three fields as soon as ... > warning message. ... in the next column FieldName, add the schema field ...
    (microsoft.public.access.forms)
  • Re: DBA_PROCEDURES / DBA_TRIGGERS
    ... with older stuff from the old schema. ... So I was trying to find out which triggers, procs, packages, synonyms, ... I did that by comparing all entries in DBA_TRIGGERS in the new schema ... DBA_PROCEDURES showing only valid procs. ...
    (comp.databases.oracle.server)