Re: Importing Databases
Date: 1997/08/01
Message-ID: <33e34d97.9618204_at_news.centroin.com.br>#1/1
On Wed, 30 Jul 1997 19:38:43 GMT, "Scott Metro" <smetro_at_world.std.com> wrote:
>I need to periodically synchronize a development database with a production
>database. I have been doing this by exporting (either full or user) from
>the production database and then dropping the user in the development
>database and then importing the user into the dev. database.
>
>Is this the best way, or is there a simpler way, that doesn't require
>dropping the user first. One problem with my way, is that the triggers
>don't seem to be coming over, and I need to recreate them manually.
You can drop all objects from the user. With this you don't need drop the user and recreate it. With the advantage that the roles and privilegies granted to the user are not lost...
You can find a good script that drop all objects from an user in the Oracle Magazine web site... Received on Fri Aug 01 1997 - 00:00:00 CEST