Thanx Mr. Arup.
On Wed, 05 Mar 2003 Arup Nanda wrote :
>Sudhakar,
>
>Unfortunately that's the only way to change teh trigger's
>ownership. But how
>does it matter, if you drop and recreate the triggers in another
>schema?
>
>Arup Nanda
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L"
><ORACLE-L_at_fatcity.com>
>Sent: Wednesday, March 05, 2003 5:19 AM
>
>
> > hello,
> >
> > Triggers were created in a user where synonyms of tables of
>other
> > user s were existing. So i have to change owner of the trigger
>to
> > the owner of the tables. Is it possible to change without
>dropping
> > the triggers and recreating them.
> >
> > Thanx,
> > Sudhakar
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: sudhakar Reddy
> > INET: sudhakarcv_at_rediffmail.com
> >
> > Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
>services
> >
>---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
>message
> > to: ListGuru_at_fatcity.com (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).
> >
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Arup Nanda
> INET: orarup_at_hotmail.com
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting
>services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail
>message
>to: ListGuru_at_fatcity.com (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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: sudhakar Reddy
INET: sudhakarcv_at_rediffmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
Received on Wed Mar 05 2003 - 23:18:42 CST
