From: Ana C. Dent <>
Date: Fri, 27 Jun 2008 14:22:09 GMT
Message-ID: <Xns9ACA4A9C3B22Danacedenthotmailcom@> wrote in news:03dc7091-6022-48cc-bf28-

> On 26 Jun., 21:27, wrote:

>> On Thu, 26 Jun 2008 09:33:02 -0700 (PDT),
>> wrote:
>> >I'm asking this because we are preparing a script to move all 
>> >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.

DBA_OBJECTS has a column named something like "LAST_DDL"; which might provide a clue Received on Fri Jun 27 2008 - 09:22:09 CDT

Original text of this message