Re: overwrite schema.table name

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 7 Nov 2005 07:02:29 -0800
Message-ID: <1131375749.852022.106640@o13g2000cwo.googlegroups.com>

But the OP says that the scripts have a hardcoded owner. So what I suggest is that the scripts be either:

1 - edited to have no owner and then by logging on as the owner ran OR

the "alter session set current_schema = target_owner" command can be used
to access either set of owner's objects from a third ID.

2 - the scripts be copied and edited to point to the new owner

Either way will work though version 1 is probably easier to maintain until such time as the two sets of objects start to vary from each other.

HTH -- Mark D Powell -- Received on Mon Nov 07 2005 - 09:02:29 CST