Posted on 2009-12-16
I have a flat file that i generated from the database with a simple pipe statements as follows
select col1||'||col2 ...... from table_name
and spooled that into a file and tried to use the dbload as follows
dbload -c E:\LX_LOG\dbl -d pstruct -l E:\LX_LOG\dbl_error.err -n 1000
but i got back the follwoing error :
The # of fields in the load file does not match the # on the FILE line
the contents of the dbl file are as follows
0-1532028-2|61880250603|ESP-R-025-P5-1-H26E3-18.0-603 |0-1532028-2.dwg |AUTO-CAD-DWGS |
that is the file i initially generated (flat file i spoeke about in the first line)
Whats the issue here :
And also when i try to dbimport a dmp file using the following
dbimport pstruct -d ol_unistarpesv -i E:\OL_UNISTARPESV_DUMP
It just stays there without spitting out anything.
Is this a privilege issue.