Re: Replicating schema to a laptop

From: Kenneth A Kauffman <kkauffman_at_nospam.headfog.com>
Date: Mon, 28 Apr 2003 16:24:38 GMT
Message-ID: <aBcra.38720$xB4.1034016@news2.east.cox.net>

"Mario" <mtechera_at_wpmc.com> wrote in message news:65c992b1.0304280445.6682c784_at_posting.google.com...
> Hello Everyone:
>
> We have a situation where we would like to replicate a database
> to a PC for local use. The use on the PC will be READ-ONLY.
>
> The replication mechanism should allow for things like schema
> changes (table or view additions/deletions, procedure addition/deletions
> etc etc).
>
> We basically want to replicate one complete schema including data.
>
> We would like to be able to start the synchronization on end-user
> demand.
>
> Can anyone suggest the best way of doing this?
>
> We would be working with Oracle 8.1.7 on W2K.
>
> Thanks for any help!!
> Mario

export using the "owner" option, then import using fromuser/touser.

ie.
exp system/manager owner=schema file=my.dmp imp system/manager fromuser=schema touser=schema file=my.dmp

ken k Received on Mon Apr 28 2003 - 11:24:38 CDT