Re: unloading text and loading text.

From: Lamar Williams <lamar_at_moOFus.com>
Date: Tue, 19 Dec 2000 18:11:17 -0800
Message-ID: <3A401544.2994B780_at_moOFus.com>


Thanks Ken,

Now how do I load the data back into the database?

Lamar

Ken wrote:

> for example, you want to spool the data to a file.
> you may type the followings in sqlplus.
>
> set head off
> spool test.txt
> select firstname||','||lastname||','||userid
> from <table_name>;
> spool off
>
> Then the file test.txt will contain what you want.
>
> Ken
>
> "Lamar Williams" <lamar_at_moOFus.com> ?????
> news:3A3172E4.E944B583_at_moOFus.com...
> > Any examples for option 1? Using comma seperated data.
> >
> > given the following table:
> >
> > Name Null? Type
> > ----------------------------------------- --------
> > ----------------------------
> > FIRSTNAME NOT NULL CHAR(32)
> > LASTNAME NOT NULL CHAR(32)
> > USERID NOT NULL CHAR(10)
> >
> > and a data file like the following
> >
> >
> > Lamar,Williams,8834
> > Joey,Thebest,83
> > Connie,isInTrouble
> >
> >
> >
> > Thanks,
> > Lamar
> >
> > Alexander Medvedev wrote:
> >
> > > Lamar Williams wrote:
> > >
> > > > What is the best way to unload a table into a human readable text
 file,
> > > > and then
> > > > load it back into my table (assumming I clean the table first)?
> > > >
> > > > I'm experience with Informix, but new to Oracle.
> > > >
> > > > Thanks,
> > > >
> > > > Lamar_at_moOFus.com
> > >
> > > Hi Lamar,
> > >
> > > There are several ways to do it.
> > >
> > > 1) unload to file by SQL*Plus, load by SQL*Loader
> > > 2) using UTL_FILE package (set of stored procedures, suplied with
 Oracle) -
> > > only on server disk, not on the client machine. UTL_FILE can open files
 for
> > > read and write both.
> > > 3) unload by Oracle Report, load by SQL*Loader
> > > 4) unload and load by Oracle Forms (you have to use text_io package in
 your
> > > form)
> > > 5) One of OAS, OWA, WEBDB on server side and browser on client side.
> > > 6) Write a simple program by some language you want (VB, C, C++, Power
> > > Objects, etc)
> > > 7) By some third-party tool (like MS Excel, for example) can interact
 with
> > > Oracle via ODBC driver
> > >
> > > and so on...
> > >
> > > Also you can make a simple (default) form by Form Builder (its a part of
> > > Developer2000, Developer-6) to query and manipulate data in your table
 in
> > > dialog.
> > >
> > > Regards Alexander Medvedev
> >
Received on Wed Dec 20 2000 - 03:11:17 CET

Original text of this message