Re: fastest method to copy data between databases

>My first thought is to use export and import. You may want to bring the
>data out of the source database using the two parameters to export
>CONSTRAINTS=N and INDEXES=N and creating them manually after the data is
>brought into the target database. The export component of this scenario
>is even better in 7.3 with the DIRECT option to export.
>
>Michael

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.

David Pelinka - Programmer/Analyst	Direct/Voice: (503)-977-4379
Portland Community College, SY CC 224	Fax: (503)-977-4987
PO Box 19000 Portland, OR. 97280-0990	Internet: dpelinka_at_pcc.edu
--------------------------------------------------------------------