i have a big problem, and it is very urgent.
hope someone helps me with this trouble.
i am transfering txt files' data to oracle tables.
oracle doesn't accept the data if it is bigger than 276 bytes ????.I chnaged the size of that column to 2000bytes,
it seems,setting up is okey, but during the data transfer an error occurs telling me that the column3 is too large for the specified buffer size. Unfortunately most of the data are larger than 276 bytes, so i have to find a workaround for this problem.
i tried to change the initial parameters for my database.
i changed the db_block_size to max value(16384) , restart the database, but still having the same error message, as if no change was made.
can someone please give me some advice how to increase the buffer size.
i also tried using CLOB for this large text field, but database doesn't accept, or i am making a mistake somewhere.
i am looking forward to your (GURUs') precious ideas and help as soon as possible.