Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table Re-design

Re: Table Re-design

From: beersa <sabeer.oracle_at_gmail.com>
Date: 3 Sep 2006 08:55:47 -0700
Message-ID: <1157298947.871845.95860@e3g2000cwe.googlegroups.com>


Sorry for wasting your time.
I will follow your advise on next time.

Sybrand Bakker wrote:
> 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 - 10:55:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US