Re: getting data from Oracle 8 to Oracle 7

[Quoted] Create database link <- look up this command from one db to the other.

Then
create table foo as select * from foo_at_dblink

Done deal. Almost that simple too...

In article <BtIX1.15$ps1.165081_at_news.rdc1.sfba.home.com>, Stephanie Wood <steph2000_at_home.com> wrote:
>Question: I work with a group of people who loaded data into an Oracle 8
>database and now want to put it into an Oracle 7 database. I can't simply
>export from oracle 8 and import into oracle 7 from what I've heard. Does
>anyone know any "easy" way to do this? I've thought about exporting into a
>flat file, comma delimited, and then importing that via sql loader into
>oracle 7. Or exporting the data and taking it into Access and then into
>Oracle. Suggestions?
>
>Thanks!
>Stephanie
>
>

--
(: Joe Brown :)				      joe_at_apache.dtcc.edu
I believe Wine is going to be great if it ever gets finished. . .
I believe Linux _is_ great even though it's not finished! ! !
I believe you have my address.  :-)