Oracle Extractor Instructions
Here are the detailed instructions for extracting required information from Oracle database systems.
Downloading the Extractor
The extOraSchema-8.jar archive contains the JRE 8 version and should work with JRE version 8 to 21.
The extractor requires ojdbc8.jar which is bundled with SQL Developer.
Determine JRE Version
To ensure the correct version of the extractor is used, please check what version of the JRE you have installed. We recommend using the JRE that comes with SQL Developer.
- Open Command Prompt
- Navigate to your SQL Developer folder
- Navigate to the sub-folder
jdk/jre - Run the command
.\java -version
If this returns 1.8 use JRE 8 version JAR, if 11 use the JRE 11 JAR, otherwise use the appropriate version from the table below.
| JRE Version | Extractor File |
|---|---|
| 8 (1.8) | extOraSchema-8.jar |
| 11 | extOraSchema-11.jar |
| 17 | extOraSchema-17.jar |
| 19 | extOraSchema-19.jar |
| 21 | extOraSchema-21.jar |
Your Encryption Key
The extractor will use an encryption key to encrypt the extracted zip archive.
- Demo or trial users will need to request the encryption key from their account manager.
- Registered customers can generate keys via the portal.
Extractor Parameters
The extractors use the following positional command line parameters:
| No. | Description |
|---|---|
| 1 | IP address or hostname of the database server |
| 2 | DB listener port on the database service |
| 3 | DB SID |
| 4 | Username to connect as. Must have SELECT_CATALOG_ROLE, or be able to select any view/table. |
| 5 | Password for the user |
| 6 | Name of schema to extract |
| 7 | Set to 'Y' to include SQL extract |
| 8 | For internal use. Always specify N |
| 9 | Name of output folder to extract objects scripts into |
| 10 | Encryption Key |
Test Mode
If just the first 6 parameters are provided, the extractor runs in ‘test’ mode, where it will check if it can connect and run a basic query. This is useful for validating connectivity before a full extraction.
Running The Extractor
Decide Location of Output
Decide where the extractor will write its output files to (this folder tree will be zipped after extraction phase is complete).
Create a Run Script
Copy and paste the following into a run script, and amend the JAVA_HOME value as appropriate.
set JAVA_HOME=K:\Oracle\Development\sqldeveloper-21\jdk\jre %JAVA_HOME%\bin\java -version echo %JAVA_HOME%\bin\java -cp "extOraSchema-8.jar;ojdbc8.jar" \ extOraSchema HOST PORT SID USER PASS SCHEMA Y N OUTPUT_DIR ENC_KEY