Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Tools to migrate stored procedures and queries

What are the tools available to migrate stored procedures and queries from Oracle 8i to Oracle 10g?

What are the tools available to migrate stored procedures and queries from Oracle 8i to Oracle 10g?
Your question does not provide enough detail about what it is you are doing so I will assume that you must migrate stored procedures from an existing Oracle 8i database to an existing Oracle 9i database, and not that you are attempting to upgrade a database to 9i.

You can either grab the code from the stored procedures through SQL*Plus by querying views such as DBA_SOURCE, or you can also do this via a GUI tool such as Oracle's Enterprise Manager or Toad. Once you have the 'create or replace …' statements for the stored procedures you wish to migrate from the Oracle8i database, you would simply log into the Oracle9i database as the proper schema owner and run them via SQL*Plus. This would create the necessary stored procedures in the 9i database.

SQL queries are not stored within the Oracle database so they are not migrated, per se. SQL queries are either run via an application, or some other interface such as reporting tools, or the SQL*Plus command line by users and DBAs.

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close