BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« Data Staging Strategy considerations | Main | Different types of Dashbords, how to choose a required one »

February 24, 2007

How to use Oracle's Metadata package for impact analysis

By: Milind Zodge

Overview
Business is always changing and you have to make some changes based on the business change.

Before doing any change you want to perform an impact analysis. Most of the data modeling tools have provision to do it. I am focusing in the article how you perform this task if you don't have a tool.

Details
Consider a case, we have Oracle database and wants to alter a column width and would like to see wherever this column is used/ referenced.

We can use Oracle's metadata package as indicated below

SET pagesize 0
SET long 90000
SET feedback off
SET echo off

SELECT DBMS_METADATA.GET_DDL('TABLE',ut.table_name)
FROM USER_TABLES ut;

This will give DDL scripts for all the tables. Now you can use any text tool like Notepad to search for the required column and find out the references.

Conclusion
There are various ways to do it. This is one of them. This will help you determining the impact exposure.

Posted by Milind Zodge at February 24, 2007 8:45 PM

Comments

I think this is one of the most important info for me. And i am glad reading your article. But should remark on some general things, The web site style is perfect, the articles is really excellent :D. Excellent job, cheers, Lynwood Tookes

Posted by: Lynwood Tookes at May 13, 2011 12:04 PM

I wonder if this is all possible, see for yourself.

Posted by: London escort at May 16, 2011 6:44 PM

Any interesting discussion is worthy of attention, this blog is definitely worth adding to your favorites.

Posted by: escort Stansted at May 16, 2011 11:32 PM

Post a comment




Remember Me?