Re: How to Import/Export Data To-From Oracle 8i Tables
Date: Sat, 21 Jul 2001 21:42:29 GMT
Message-ID: <tsPO6.5$dJ4.10515_at_news.nyc.globix.net>
Ray,
[Quoted] 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:29 CEST