#8 Export ALL REST Definitions

Exporting REST Definitions as bulk is helpful when you want to backup REST Definitions.

Oracle provides very good , simple and lightweight tool  , it's SQLcl (SQL command line) to  interact with DataBase.

Download SQLcl from here

Here are the steps to EXPORT REST:

1. Extract downloaded file  to  D:\Oracle\sqlcl
2. Go to : D:\Oracle\sqlcl\bin
3. Run the sql.exe 
4. Enter user name and password :
• Username? (''?) TREST/trest@ORCL
• now, you must be connected to Oracle Database
5. Type in : SPOOL D:\REST_Export.SQL
6. Type in : REST EXPORT
7. Type in : SPOOL OFF;

Explain:

• Step#5  : locate the file path where to save the output
• Step#6  : Identify  which Module to export , you can choose one module or all modules
• Step#7  : End writing data to output file, and saving data

Full copy of REST definitions are saved in the path :  D:\REST_Export.SQL you