Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: A $64k ? (UNIX commands on NT)

Re: A $64k ? (UNIX commands on NT)

From: <nwhitehead_at_rocketmail.com>
Date: 1997/10/14
Message-ID: <3443b44c.1394725@news.cybernex.net>#1/1

Go to www.windows95.com.
They have a few sets of UNIX utilties for Win32. If you really need hard core UNIX support for NT, look for a product called OpenNT.

Nicholas
nwhitehead_at_rocketmail.com

>
>--------------59B974EC142ED31D179B8BF9
>Content-Type: text/plain; charset=iso-8859-1
>Content-Transfer-Encoding: 8bit
>
>I need to convert a file from EBCDIC to ASCII and then use it as input
>to SQL*Loader using as little disk space as possible. On UNIX machines
>this can be accomplished easily using “dd” to do the character
>conversion and a FIFO pipe to handle the I/O. An example:
>
>$ mknod fifo_pipe p
>$ dd if=/dev/rmt/0 of=fifo_pipe conv=ascii &
>$ sqlldr userid=foo/bar data=fifo_pipe control=foobar.ctl
>
>What is the NT solution, or is there none?
>
> \\|//
> (0-0)
> +---------oOO----(_)---------------+
> | Brian P. Mac Lean |
> | Senior Oracle DBA |
> | brian.maclean_at_goodnet.com |
> | brian.maclean_at_sendero.fiserv.com |
> +----------------------oOO---------+
> |__|__|
> || ||
> ooO Ooo
>
>--------------59B974EC142ED31D179B8BF9
>Content-Type: text/html; charset=iso-8859-1
>Content-Transfer-Encoding: 8bit
>
><HTML>
><TT>I need to convert a file from EBCDIC to ASCII and then use it as input
>to SQL*Loader using as little disk space as possible.&nbsp; On UNIX machines
>this can be accomplished easily using “dd” to do the character conversion
>and a FIFO pipe to handle the I/O.&nbsp; An example:</TT><TT></TT>
>
><P><TT>$ mknod fifo_pipe p</TT>
><BR><TT>$ dd if=/dev/rmt/0 of=fifo_pipe conv=ascii &amp;</TT>
><BR><TT>$ sqlldr userid=foo/bar data=fifo_pipe control=foobar.ctl</TT><TT></TT>
>
><P><TT>What is the NT solution, or is there none?</TT><TT></TT>
>
><P><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>\\|//</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>(0-0)</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +---------oOO----(_)---------------+</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
>Brian P. Mac Lean&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>|</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
>Senior Oracle DBA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>|</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
>brian.maclean_at_goodnet.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
>brian.maclean_at_sendero.fiserv.com |</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +----------------------oOO---------+</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>|__|__|</TT>

 <BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>|| ||</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>ooO Ooo</TT></HTML>
>
>--------------59B974EC142ED31D179B8BF9--
>
Received on Tue Oct 14 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US