Installing JSON Parser in a Remote Database

You can install JSON support in a remote database by running the loadjsonschemagen or loadjsonschemagenWithSN scripts.

1. Log in to the computer where SQL Developer is installed.
2. Navigate to the scripts directory:
   cd SQL_Developer_Home\sqldeveloper\dataminer\scripts
3. Start SQL*Plus as SYS:

   SQLPLUS sys / as sysdba

4. Run either the SID or Service Name version of the script:
   @loadjsonschemagen sys_user sys_password host port SID jar_path

   or

   @loadjsonschemagenWithSN sys_user sys_password host port service_name jar_path

   where the value of jar_path is:

   c:\SQL_Developer_home\sqldeveloper\extensions\oracle.dmt.dataminer\lib