RE: View Problem

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 1 Oct 2004 12:42:26 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNEEHPCJAA.lex.de.haan@naturaljoin.nl>

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_at_gmail.com] Sent: Friday, October 01, 2004 11:00
To: lex.de.haan_at_naturaljoin.nl
Cc: srinivast_at_kpitcummins.com; oracle-l_at_freelists.org 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_at_naturaljoin.nl> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Srinivas T
> Sent: Friday, October 01, 2004 10:12
> To: oracle-l_at_freelists.org
> 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

Received on Fri Oct 01 2004 - 05:38:08 CDT