load csv failed

[vkjuju]

Thanks for sharing , have you hit the following error ? any advice would be appreciated.

SQL> load bank_accounts bankgraphdataset/bank_accounts.csv new;
load bank_accounts bankgraphdataset/bank_accounts.csv new
*
ERROR at line 1:
ORA-00900: invalid SQL statement
Help: https://docs.oracle.com/error-help/db/ora-00900/

[vkjuju]

sorry, I forgot to run oracle-graph-23c-sqldeveloper.sql, please ignore my previous issue

[vkjuju]

sorr , after running that oracle-graph-23c-sqldeveloper.sql, I still hit the same error as shown below:

SQL> load bank_accounts bankgraphdataset/bank_accounts.csv new;
load bank_accounts bankgraphdataset/bank_accounts.csv new
*
ERROR at line 1:
ORA-00900: invalid SQL statement
Help: https://docs.oracle.com/error-help/db/ora-00900/

[rahul-tasker]

Hi, it looks like the load command is not recognized. Are you using SQLcl, if so what version?

https://docs.oracle.com/en/database/oracle/sql-developer-command-line/24.1/sqcug/loading-file.html#GUID-44F05C51-9AAF-47A1-94B4-C2AAB4F1EF6F