Hello, first time asking a question in this community.
I'm trying to load data from a CSV file into an existing table in APEX. The CSV has over 900,000 rows so it is a pretty large file. When using the data loader in APEX, it completed but only about 33,000 were inserted, the rest failed. The error message it gave was:
"ORA-01653:unable to extend table [WORKSPACE_NAME.TABLE_NAME] by 128 in tablespace APEX_xxxxxxxxxxxxxx"
The "xxx" were several numbers I assume uniquely identify the tablespace.
Previously I had imported a CSV with over 100,000 rows into a different table without any problems so I don't believe 33,000 is the row limit.
So my question(s) are what is the max row size to import a CSV, assuming there is one?
What would be an easy-ish way to import a file that large without having to break it up into multiple files? Thanks.