Re: fastest method to copy data between databases

David Pelinka wrote:

> Thanks. It doesn't appear that export supports views. Will I need to export
> each individual table, then recreate the view in the data warehouse? That is a
> possibility, but I'd need to pare down some large tables to include only the
> required fields, and create the functions in the data warehouse also.
>
> Your thoughts are appreciated.

Doing a user export will bring the view definitions out of the source data repository. The SQL statements required to rebuild the views will be written to the export file, and they will be run as import reads the contents of the export file into the target repository.

Michael

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################