txt file with import utility
From: Tomislav Kokoska <tkokoska_at_varteks.com>
Date: Tue, 4 Feb 2003 12:18:52 +0100
Message-ID: <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
)
Received on Tue Feb 04 2003 - 12:18:52 CET
Date: Tue, 4 Feb 2003 12:18:52 +0100
Message-ID: <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!!
Received on Tue Feb 04 2003 - 12:18:52 CET