Re: Question: Export and Import

cmtnl_at_worldaccess.nl wrote:

>I am an user of an Oracle application. The database of the application has two
>owners with their own tables: 'demo' and 'production'. The tables of demo are
>identical to the tables of production. Each table has constraints and triggers.
>QUESTION: Which procedure must I follow to empty the tables of 'demo' and to
>fill them with the contents of the tables of 'production' using the import and
>export tool. Maybe you know also a site where I can download the import and
>export tool.
>
>Thanks in advance,
>Paul Hensgens, The Netherlands
>

Paul,

It would be easier to "truncate" the demo tables, then populate them by doing an insert into demo as select * from production. The truncate command gets rid of the data, removes the high water mark and leaves the table intact. It also doesn't create any redo like deleting * from demo would do.

Hope this helps.

Herman Means
Oracle DBA Received on Sat Nov 02 1996 - 00:00:00 CET