have a table created with quoted name: create table "Dialog" (..) in a schema called FFO.
I am trying to use SQLcl (on Windows) to unload (export) the data from this table by by running:
unload table "Dialog"
--> Error message: TABLE does not exist: FFO."Dialog"
I prefix with schema name:
unload table "FFO"."Dialog"
--> Error message:
Invalid option specified off. Remaining options are ignored.
Value is not valid for option "Dialog". Remaining options are ignored.
I have tried to put the schema name in lowercase, uppercase, quoted and not, but gets the same error message.
Is this a bug in SQLcl or is it an unload option in SQLcl that I have missed out?
Greatful for all tips and help.
Note:
From SQL Developer (gui) I am able to export/unload from table "Dialog".
Unloading a table with a name that is not quoted is no problem:
SQL> create table dialog_not_quoted as select * from "Dialog";
unload table dialog_not_quoted
--> Success
...
Number of Rows Exported: 214
** UNLOAD End ** at 2023.01.26-15.41.57