Re: txt file with import utility

"Tomislav Kokoska" <tkokoska_at_varteks.com> wrote in message news:<b1o7m4$atc$1_at_sunce.iskon.hr>...
> ____________________________________________________________________________
> ________
> Greetings to group!
> I need to import some txt file into oracle (8.1.7 version). I was trying
> with "imp" command but no result. SQL Plus reported me:"SP2-0734: unknown
> command beginning "imp sys..." - rest of line ignored."
> I created ora table with this simple strukture:
> WORKERS(
> idworker number(3),
> idwork_place number(2)
> birth date
> )
>
> PEOPLE.TXT file content:
> 0010131051976
> 0060820011965
> 2560201011968
>

Oracle's imp utility only works if the file was created using exp utility. From the text it looks like a fixed width text file. If you convert it to delimited file, then you can use Oracle's Sql*Loader utility.

Regards
/Rauf Sarwar Received on Tue Feb 04 2003 - 16:05:15 CET