Re: txt file with import utility
Date: 4 Feb 2003 07:26:25 -0800
Message-ID: <a20d28ee.0302040726.1a3d8b1d_at_posting.google.com>
"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
>
> please advise me!!
> ____________________________________________________________________________
> ________
imp can only work with export files.
You need to use sql*loader. As imp and exp this is described in the
Oracle Server Utilities Manual.
Hth
Sybrand Bakker
Senior Oracle DBA
Received on Tue Feb 04 2003 - 16:26:25 CET