Re: Data extraction using SQL....

From: godmann <allanwtham_at_yahoo.com>
Date: 24 Oct 2001 19:35:11 -0700
Message-ID: <95cd51c.0110241835.17ffb86a@posting.google.com>

Hi there,

The best is to spool all your data to delimited ASCII files and load it into Oracle 8 or 8i using Sql Loader as highlighted by M.D. Powell. This is the way with less problem and guarantee to work.

You can select columns from user_tab_columns once you login as the user who own all the tables and dynamically spool out the data according to the columns. It should be pretty straight forward.

or alternatively you can import into Oracle 7 first you dump data and then export Oracle 7 data to be imported into Oracle 8. From Oracle 6 dump to Oracle 8 bound to have some issues. I haven't tried it myself though.

Allan W. Tham
DBA Received on Wed Oct 24 2001 - 21:35:11 CDT