Re: Database copy question 2 ..(HELP!!!)

JK,

You are querying all tables your user have access rights. Please make sure you are filtering out all tables owned by 'SYS, 'SYSTEM', OUTLN, ... or just include OWNER = 'your application owner'.

Reid

JK Yao wrote:

> dear all,
>
> After I write an procedure to run what I select from the script :
>
> SELECT 'UPDATE ' || TABLE_NAME || ' SET COST = 1 ;'
> FROM ALL_TAB_COLUMNS
> WHERE COLUMN_NAME = 'COST' ;
>
> I create upgrade some table and the error code is
> ORA-01733: virtual column not allowed here.
> I cannot find those error table, coz there are no such tables.
>
> Question:
> Will the all_tab_columns include objects other than table? It is
> supposed to include just "Table" information, isn't it?
> Please clarify. Thanks a lot.
>
> JK
>
> Reid Lai <reidlai_at_netvigator.com> wrote in message news:<3B97A31A.AE8F97CE_at_netvigator.com>...
> > SELECT
> > 'UPDATE ' || TABLE_NAME || ' SET COST = 1 ;'
> > FROM
> > ALL_TAB_COLUMNS
> > WHERE
> > COLUMN_NAME = 'COST' ;
> >
> > JK Yao wrote:
> >
> > > dear all,
> > >
> > > Is there any fast way to set all column called 'cost' to 1? Since I
> > > have 'Cost' column involved in so many table, I need some script of
> > > special way to done my job.
> > >
> > > Please clarify. Thanks a lot.
> > >
> > > I use Oracle8.1.6 in Solaris2.6
> > >
> > > regards,
> > > JK
Received on Sat Sep 08 2001 - 14:06:21 CDT