I am trying to insert into an external table and I get the
What are ways to populate an external table?
Answer: External tables are usually loaded from external sources such
as spreadsheet data (csv format) or rows that are punched into a
flat file in column delimited format.
Limitations on Oracle External Tables
In Oracle, external tables have several limitations, including:
No support for DML. Oracle external tables are
read-only, but the base data can be edited in any text editor.
Poor response for high-volume queries.
Oracle external tables have a processing overhead and are not
suitable for large tables.
You can also use Oracle utilities such as utl_file to write
to an external file, which is mapped to an external table.
oerr utility shows this for the ORA-30657 error:
ORA-30657: Operation not supported on external organized table
Cause: User attempted on operation on an external table
which is not supported.