Re: Table Unload?...

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 13 Jan 1999 21:20:19 -0800
Message-ID: <369D7E93.4A70D629@us.oracle.com>

Chris

There are a couple of approaches that can be taken to unload Oracle data:

Oracle's Export utility creates a binary file that is only readable by Oracle's import utility, as earlier stated by others.
From SQL*Plus, you can run a script that does something like this:

set heading off feedback off echo off verify off scan off pagesize 0 (there may be some others necessary that I can't remember off the top of my head) spool table_output.log
select * from table_you_want_unloaded;
spool off

3. If there are lots of tables to do, you can use SQL to generate the SQL needed to produce the script in answer 2 for multiple tables

4. There are a number of databases that you can connect to via ODBC which can then either access Oracle via ODBC or vice versa

5. You could use replication technology if you want to get really complex.

Hope this helps

Pete

Chris Totten wrote:

> 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

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Jan 13 1999 - 23:20:19 CST