RE: View Problem

["Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>]

a view has no rows, so refreshing is irrelevant in this context.
the only thing you can do is a "create or replace view xview as select *
from x"

there is an "alter view ... compile" command in SQL,
but that's only meant to recompile invalid indexes.

Kind regards,
Lex.

-------------------------------
visit http://www.naturaljoin.nl
-------------------------------
skype me <callto://lexdehaan>


-----Original Message-----
From: Chirag DBA [mailto:ChiragDBA@xxxxxxxxx]
Sent: Friday, October 01, 2004 11:00
To: lex.de.haan@xxxxxxxxxxxxxx
Cc: srinivast@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: View Problem


any way to refresh the view ( though this is not Materialized one.) ????

I tried refresh n rebuild. Is this possible/ tried by someone ??

 - Chirag




On Fri, 1 Oct 2004 11:22:29 +0200, Lex de Haan
<lex.de.haan@xxxxxxxxxxxxxx> wrote:
> Hi  Srinivas,
>
> the "*" in your create view statement is expanded into a list of column
> names --
> check out the USER_VIEWS data dictionary view. this way the view stays
> valid,
> as long as you don't drop the column :-) but you will have to re-create
the
> view
> to have the added column show up...
>
> Kind regards,
> Lex.
>
> -------------------------------
> visit http://www.naturaljoin.nl <http://www.naturaljoin.nl>
> -------------------------------
> skype me <callto://lexdehaan>
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Srinivas T
> Sent: Friday, October 01, 2004 10:12
> To: oracle-l@xxxxxxxxxxxxx
> Subject: View Problem
>
> HI,
> I have created a view .. on the table x;
>
> select * from x
>
>  SNO
> -----
>    1
>    2
>    3
>    4
>    5
>    6
>    7
>    8
> create view xview as select * from x;
>
> Added a column to the table x
>
> alter table x add (sal number);
>
> select * from x;
>
>  SNO        SAL
> ----- ----------
>    1
>    2
>    3
>    4
>    5
>    6
>    7       1000
>    8       2000
>
> Select * from xview..
>
>  SNO
> -----
>    1
>    2
>    3
>    4
>    5
>    6
>    7
>    8
>
> How should I get reflected this in myview......
>
> Thanks in advance..... Srinivas.....
>
> Regards,
> Srinivas
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>



--
http://www.freelists.org/webpage/oracle-l

Other related posts:

View Problem

RE: View Problem

RE: View Problem

RE: View Problem