Hello
When I want to export from the RESTful Data Service in Oracle APEX, I must connect via sqlcl with the same schema that I defined in the module.
I have over 100 schemas, and I want to back up the RESTful Data Service into separate SQL files every day.
When I connect via SQLcl using the SYS or SYSTEM user, it doesn't recognize the modules at all. Even if I run the ALTER SESSION SET CURRENT_SCHEMA command, this command 'rest modules ' doesn't find any REST modules.
What do you think is the issue, and is there any practical solution for backing up this way? Do I need to have the passwords for all the schemas? That doesn’t seem correct!