RE: View Problem
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: "Chirag DBA" <ChiragDBA@xxxxxxxxx>
- Date: Fri, 1 Oct 2004 12:42:26 +0200
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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
