SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trying to load a csv file using SQLCL LOAD command fails with ORA-00942 when table_name length is above 30

meravkeAug 17 2025 — edited Aug 17 2025

I am trying to load a csv file into a table, using SqlCl LOAD command, but the load fails with “ORA-00942 table or view does not exists” .

The error is wrong, table do exist, and has all permission.

Table length in 33 bytes.

I have noticed the the error message had cut the table name, which made me suspect that table length might be the issue here (above 30 bytes, which was Oracle's old limit on object_name) .

When I renamed the table to a 30 bytes name, the LOAD command succeeded.

I am using sqlcl 21.4, on oracle 19.22.

Is there a known limit on table_name length for LOAD command? was this fixed in newer versions?

Thanks,

Merav

This post has been answered by thatJeffSmith-Oracle on Aug 18 2025

Jump to Answer

Added on Aug 17 2025

#load, #ora-942, #sqlcl

2 comments

37 views