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

Home -> Community -> Usenet -> c.d.o.misc -> same table_name with different owners

same table_name with different owners

From: Kenneth Yeung <kenneth_at_wetwetwet.com>
Date: 1997/11/17
Message-ID: <34701BBF.BB673324@wetwetwet.com>#1/1

Hi,
I need some suggestions on these.
I need a efficient way to manage many ( over 100) table which have the same table_name but different owners.
Everytime when I need to alter the tables. I need to alter the individual table one by one. Sometimes I may miss one or two. Is there a way to:
1. check if a column exists in the all tables ( I don't want to desc a table at a time)
2. alter all tables with the same table_name but different owner.

Thanks
K.C. Received on Mon Nov 17 1997 - 00:00:00 CST

Original text of this message

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