Forum Discussion
Helper ILoad Lakehouse data to Oracle
Hi caomayan ,
I noticed in your error message Message=ORA-00904: “CREATED_BY”: invalid identifier, which is usually caused by case-sensitive issues. Normally, Oracle tables and columns are not case-sensitive and cannot contain punctuation or spaces. However, if you use double quotes to create an identifier with quotes, you must always refer to the identifier with double quotes and the correct case.
If you want to learn more about it, you can read this topic: oracle - Why do I have ORA-00904 even when the column is present? - Stack Overflow
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi caomayan ,
I noticed in your error message Message=ORA-00904: “CREATED_BY”: invalid identifier, which is usually caused by case-sensitive issues. Normally, Oracle tables and columns are not case-sensitive and cannot contain punctuation or spaces. However, if you use double quotes to create an identifier with quotes, you must always refer to the identifier with double quotes and the correct case.
If you want to learn more about it, you can read this topic: oracle - Why do I have ORA-00904 even when the column is present? - Stack Overflow
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThanks so much Yilong! I have redone the table creation and remapping, the load is successful!