External table in Oracle 10g
Posted on 2006-11-16
Hi I used the following to load data.
CREATE TABLE DATA_LOAD_CTR
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY LSHR_LOAD_DIR
( RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY "'"
MISSING FIELD VALUES ARE NULL
REJECT LIMIT UNLIMITED
The above script works fine in development database and inserts about 14000 record. But the same inserts only one record in the staging database. It does not show any error. Why would it insert only one record from the flat file. Have I to mention table space here? If so how can I do that for this table.