Re: getting data from Oracle 8 to Oracle 7

[Quoted] Just to add flexibility and complication, SQL*NET has a copy command, given you are on a network. Look up the exact syntax but it is something like:

  copy from fred/betty_at_cpu1 touser barney/wilman_at_cpu2 append select * from foo;

In article <70pb2o$i12$1_at_apache.dtcc.edu>,   joe_at_hopi.dtcc.edu (Joe Brown) wrote:
> 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. :-)
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 22:25:31 CEST