Re: Table Unload?...

From: Chris Totten <ctotten_at_cix.compulink.co.uk>
Date: Wed, 13 Jan 1999 16:52:00 GMT
Message-ID: <F5IC6o.D1A@cix.compulink.co.uk>

In article <369CC2F7.108BC255_at_nau.edu>, glen.upreti_at_nau.edu (Glen Upreti) wrote:

> You could use oracle's export utility, but be advised export flat files
> can only be read by oracle's other utility import.
> Hope this helps
> Glen
>
>
>
> Chris Totten wrote:
> >
> > Is there any way to backup a single table under Oracle 7.x? We're more
> > used to SQLS6.5 and it has a utility called BCP (Bulk Copy) that
> > allows
> > you load/unload a single table in either native or ASCII format. Does
> > Oracle have anything similar?
> >
> > Thanks for reading - if you have any help could you reply to the
> > following
> > e-mail address because I often miss posts on Usenet :
> >
> > mailto:chris_at_task.co.uk
> >
> > Thanks,
> >
> > //chris

Is there no way to export/import in a format that's compatible with other databases? I can understand if BLOBs can't be exported but most of our tables are "standard"..

Thanks,

//chris Received on Wed Jan 13 1999 - 10:52:00 CST