Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Copying schemas ?
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
![]() |
![]() |