Tools to migrate stored procedures and queries
What are the tools available to migrate stored procedures and queries from Oracle 8i to Oracle 10g?
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments