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

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

Export triggers to a different schema

From: Tim Shute <tshute_at_nisoft.com>
Date: Wed, 28 Nov 2001 10:37:06 +0000 (UTC)
Message-ID: <0f45be9852cd8b54236083d331cc4f0e.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 - 04:37:06 CST












Original text of this message













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