Oracle

Instructions to extract Oracle code.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

The first step for migration is getting the code that you need to migrate. There are many ways to extract the code from your database. However, we recommend using the extraction scripts provided by Snowflake.

All the source code for these scripts is open source and is available on GitHub.

Prerequisites

• Access to a server with an Oracle database.

• Permission to run shell scripts with access to the server.

• Tools to connect to the Database like sqlplus or sqlcl

Installing the scripts

Go to https://github.com/Snowflake-Labs/SC.DDLExportScripts/

From the Code option, select the drop-down and use the Download ZIP option to download the code.

Decompress the ZIP file. The code for Oracle should be under the Oracle folder

When the script is done, the output folder will contain all the DDLs for the migration.

Follow the Usage instructions to modify the files and run them on your system.

You can then compress this folder to use with SnowConvert

$ zip -r output.zip ./output