Re: Changing of trigger owner

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