search

oracle-samples / pgx-samples

Applications using Parallel Graph AnalytiX (PGX) from Oracle Labs
https://www.oracle.com/technetwork/oracle-labs/parallel-graph-analytix/overview/index.html
Other
45 stars 25 forks source link

load csv failed #17

Open vkjuju opened 2 months ago

vkjuju commented 2 months ago

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 commented 2 months ago

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

vkjuju commented 2 months ago

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 commented 2 months ago

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