Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Export triggers to a different schema

Export triggers to a different schema

From: Tim Shute <tshute_at_nisoft.com>
Date: Wed, 28 Nov 2001 11:04:57 +0000 (UTC)
Message-ID: <98e6d52465787bd3be32ddf830670d71.46509@mygate.mailgate.org> 





Hi


I'm trying to export data from one database and import into another, into a
different schema. I'm using the FROMUSER and TOUSER options on IMP.EXE, but the
triggers aren't coming across as they reference the original schema owner.
How can I get them across?



TIA





-- 
Posted from  [62.253.227.30] 
via Mailgate.ORG Server - http://www.Mailgate.ORG


Received on Wed Nov 28 2001 - 05:04:57 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US