Re: How to Import/Export Data To-From Oracle 8i Tables

Also check out NXTRact at http://www.kiyoinc.com/nxtract.html

There is information on Oracle export and import and working with .DMP files.

On Wed, 23 May 2001 17:44:53, Ray Vonhollen <RVONHOLLEN_at_pacbell.net> wrote:

> Vladimir,
>
> Thanks very much for the information. It appears that exp.exe and
> imp.exe are pretty much dependant upon one anothers file format as
> imp.exe needs to use a exp.exe generated file.
>
> I have also found SQL*LOADER via your kindly direction to the Ora Tech
> Network site.
>
> One more question, have you ever run across any 3rd-party utility that
> easily accepts, as its parameters the
> schema,servername,password,tablename and a comma or pipe delimited text
> file?
>
> Thanks again for all your help.
>
> Ray.
>
> Vladimir Ivanovich wrote:
> >
> > Ray,
> >
> > First you have to create a parameter file.
> > Export example: parfile_name 'D:\EXP_TEST.txt'
> >
> > TABLES=SHEMA_NAME.TABLE1,SHEMA_NAME.TABLE2,SHEMA_NAME.TABLE3
> > FILE=D:\EXP_TEST.dmp
> > LOG=D:\EXP_TEST.log
> > COMPRESS=N
> > DIRECT=Y
> > FEEDBACK=1000
> > STATISTICS=NONE
> > CONSISTENT=Y
> >
> > Thank run from the command line:
> > EXP.EXE SYS/<password>_at_<SID> PARFILE=D:\EXP_TEST.txt
> >
> > See Oracle Docs for more info, or type exp help=y at the command prompt
> >
> > Vladimir Ivanovich, Oracle DBA
> >
> > "Ray Vonhollen" <RVONHOLLEN_at_pacbell.net> wrote in message
> > news:3B0AE616.142968C6_at_pacbell.net...
> > > Is there any command line utility, similar to bcp (bulk copy program)
> > > that one can use to Import and or Export data from Oracle 8i tables?
> > > Usually format is csv, pipe delimited or tab delimited text files.
> > >
> > > Thanks in advance for your help.
> > >
> > >
> > > Ray
Received on Sat Jul 21 2001 - 23:42:51 CEST