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

Vladimir,

[Quoted] [Quoted] 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:38 CEST