how to insert dbf file in oracle9i table using external table concepts
good or not good? that is the ....
CREATE OR REPLACE DIRECTORY
EXT_DIR AS
'c:\TEMP\ext';
GRANT READ, WRITE ON DIRECTORY EXT_DIR TO <USER> WITH GRANT OPTION;
drop table ext_table_fixed;
create table ext_table_fixed (
field_1 char(3),
field_2 char(30)
)
organization external (
type oracle_loader
default directory ext_dir
access parameters (
records delimited by ' '
fields (
field_1 position(1: 3) char( 3),
field_2 position(4:34) char(30)
)
)
location ('file.DBF')
)
reject limit unlimited;
select * from ext_table_fixed;