For the first time i used this to load data into oracle table. But every month the load is to happen from the csv. Is there any way where i can directly insert the data into the already existing table.
create table ext_table_csv (
organization external (
default directory ext_dir
access parameters (
records delimited by newline
fields terminated by ','
missing field values are null
reject limit unlimited;
Can anyone please let me know how to do this, iam stuck at this point. By using SQL loader v can use APPEND but is there a way using the external tables, to append.
Please let me know if someone can see this thread, becuase if i go to the thread list i do not see this thread. If i do not get a reply i'll try to post it again.
you should better ask your question in the SQL and PL/SQL Forum at: SQL and PL/SQL
There are experts who can help you better on this pure Oracle issue, I don't see your question related to any migration.