Rajneesh Kumar

• Oct 11th, 2006

 

YEs,The view will work fine.When we Re-create table with the same name view will work.If the table has some records entered then the old view also display the new record.so,it is completely work.

Thanks

dev

• Oct 17th, 2006

 

HI,

But it's not working. i created a view and dropped the base table and again i created a table ven though it's not working.

Are u sure that the view will work.

Thanks.

Dev

vijay kumar

• Oct 24th, 2006

 

yes its true it will work fine even the base table is recreated.

+09900416921

vijay

aseemnaithani

 Profile Answers by aseemnaithani Questions by aseemnaithani

• Oct 25th, 2006

 

i think u need to recomplie the view .. as it would have become invalid.. after droping the table...

Neeraj

• Nov 7th, 2006

 

you are correct. Good.

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Dec 25th, 2006

 

Hi all, the view will work.it does not need to be recompiled.Regards,Gnagadhar

madhavi

• Jan 3rd, 2007

 

View will work.

lieni

 Profile Answers by lieni 

• Jan 16th, 2007

 

It depends how the view is accessed first time. If you access the viewfirst in a plsql programm, plsql will recompile invalid objectsauomatically. On the other side, if you access the view first thou JDBCit will not be recompiled an remains invald.

rayadurgamsudha

 Profile Answers by rayadurgamsudha 

• Mar 11th, 2007

 

yes the view will work if the base table is dropped and again created with the same name and same records. it must have all the initial records , new records can be added though to the newly created table. hte new records will be show in the view too.
regards,
       sudha.

Ashok Kumar choubey

• May 23rd, 2007

 

It will work either after base table drop and recreate or base table alteration. 

Enjoy

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Feb 5th, 2008

 

The view will be INVALID,so you need to re-compile it after create that base table...