Re: how to export data from oracle for other database usage ?

Julio wrote:
> =

> stephen escribió:
> >
> > hi ,
> > can anyone tell me how to export data from oracle into a datafile whi=
ch
> > will be used to import into database other than oracle (eg db2) ?
> >
> > can i use export feature ???
> =

> No, the export utility is only valid to dump data from oracle to oracle=
. What I
> usually do, not recommended when you have a big number of tables, is to=
 spool
> data to a plain text file, table by table.
> =

There are a lot of different ways this can be accomplished. The flat file=

approach is one means. Running a daemon server process is another. What y= ou
need to define is your application environment and what your goals are fo= r
performance. Received on Thu Feb 03 2000 - 07:18:36 CST