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 -> Copying schemas ?

Copying schemas ?

From: Jarek Palka <triss_at_zeus.polsl.gliwice.pl>
Date: Tue, 14 Jul 1998 16:40:03 +0200
Message-ID: <6ofqjs$fru$1@sunsite.icm.edu.pl>


I'd like to copy all objects from one schema to another schema. I invoke export utility (exp73) in user mode and export all objects of schema TEST to export file. Than I want import these objects to schema DEMO. I invoke import utility in user mode. All objects were imported OK without triggers. In export file trigger definition looks like :

     create or replace trigger TRIG000 before (...) ON TEST.ATAB. Import utility creates trigger TRIG000 in schema DEMO, but this trigger is fired when an action occurs on table ATAB in schema TEST, not in schema DEMO.
How Can I change this without manually editing export file ?

Jarek Palka, P.I. KAMSOFT
Katowice, Poland Received on Tue Jul 14 1998 - 09:40:03 CDT

Original text of this message

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