ORDS, SODA & JSON in the Database

Announcement

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!

Export and Import ORDS

Mohammad ShaddadMay 20 2020 — edited May 20 2020

Hi All

Kindly, I have get and post ORDS web service, is there is a SQL script to extract all web service source code (DML) so I can extract and execute in another database?

DB:11.2.0.4.0

I found this simple SQL but it's showing only the trigger procedure not the full code which I used when I create the web service (ex: enable_schema, define_module, define_template, define_handler and define_parameter)

SELECT NAME
      ,Uri_Prefix
      ,Uri_Template
      ,Method
      ,Source_Type
      ,SOURCE
  FROM User_Ords_Modules   a
      ,User_Ords_Templates b
      ,User_Ords_Handlers  c
 WHERE a.Id = b.Module_Id
   AND b.Id = c.Template_Id

Thanks ...

This post has been answered by thatJeffSmith-Oracle on May 20 2020

Jump to Answer

Added on May 20 2020

#export, #import

1 comment

736 views