For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello
Is there a way to export ORDS RESTFul Wesbervices created in a schema through command line?
We need to automate it to be deployed to different environments.
Regards,
Habib
One option, use the SQLcl REST command.
Tim shows how here
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-use-sqlcl-to-display-ords-web-service-definitions
Thanks Jeff. It helped.
However wouldn't it be better if expdp exports webservices too?
That would be a request for the database team.
RESTful Web Services aren't database objects in and of themselves, so I imagine their answer would be 'no.'
You can see where we store the definitions in the data dictionary, so in addition to the SQLcl solution, and our existing PL/SQL API, you could always write your own queries/SQL scripts. But i'd rather you fall back on SQLcl's code so you dont' have to maintain anything.
Is there also a way to export the Privileges or is it Modules only?