Re: Table Re-design

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 03 Sep 2006 10:11:17 +0200
Message-ID: <rd3lf2tc8crjnlmpmv9kcgooc7bc2eq4mk@4ax.com>

On 3 Sep 2006 00:00:25 -0700, "beersa" <sabeer.oracle_at_gmail.com> wrote:

>I am using Oracle9i.
>In my application, a table needs to re-design to scope with new user
>requirements. I need to add two more fields. The tables in DB are
>originally designed by my ex-colleague. There are no detail documents
>about the DB. So, I am afraid that there will be dependency problem
>after adding two new fields.The re-designed table is using by other
>tables, packages..
>How can I find the dependency of the re-disgned table?
>
>Thanks.
>
>Cheers
>BEERSA.
select * from dict where table_name like '%DEPEND%'

or by searching on DEPEND on http://tahiti.oracle.com

This type of question is best answered by using appropiate search facilities, instead of wasting someone elses time.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Sep 03 2006 - 03:11:17 CDT