Home » SQL & PL/SQL » Client Tools » view problem (orace 10g)
view problem [message #408204] Mon, 15 June 2009 05:23 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
why in oracle sql developer on left hand side when i click on view tab it is showing 'x' mark on some view names even though it is proper and it is showing no errors,but it is displaying x mark on them.can you explain me why it is diplaying like that

CREATE OR REPLACE FORCE VIEW "EZEMRXCCHIT"."EMRVWSCREENINGDETAILS" ("SCREENING_ID", "SCREENING_REFERENCE_ID", "PATIENT_ID", "RECORD_DATE", "COMMENTS", "USER_LOGIN", "PATIENT_CONDITIONS", "STATUS", "ENCOUNTER_ID", "DESCRIPTION") AS 
  ( 
 SELECT SCREENING_ID,SCREENING_REFERENCE_ID,PATIENT_ID,RECORD_DATE,COMMENTS,
   USER_LOGIN,PATIENT_CONDITIONS,EMRPatientScreeningDetails.STATUS,ENCOUNTER_ID,DESCRIPTION
   from EMRPatientScreeningDetails
   inner join EMRScreenImmunLkup on SCREENING_REFERENCE_ID=SCREEN_IMMUN_ID
   where  EMRPatientScreeningDetails.STATUS='Pending'
 );

Re: view problem [message #408205 is a reply to message #408204] Mon, 15 June 2009 05:35 Go to previous messageGo to next message
pablolee
Messages: 2658
Registered: May 2007
Location: Scotland
Senior Member
Try refreshing the list of views.
And please dit your post so that your code does not exceed 80 characters per line.
Thanks.
Re: view problem [message #408206 is a reply to message #408205] Mon, 15 June 2009 05:38 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
after refreshing too i am having the x mark.what would be the reason for this .will it effect anything or else i have to compile the view again as it is having some data in it.will it effect view data after recreating same view.
Re: view problem [message #408210 is a reply to message #408206] Mon, 15 June 2009 05:52 Go to previous messageGo to next message
Littlefoot
Messages: 19894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
rajasekhar857
it (view) is having some data in it.will it (recreating the view) effect view data after recreating same view.

It seems that you should read some documentation about views - what they are and what they do (or do not) contain.
Re: view problem [message #408211 is a reply to message #408204] Mon, 15 June 2009 05:54 Go to previous messageGo to next message
cookiemonster
Messages: 11287
Registered: September 2008
Location: Rainy Manchester
Senior Member
All the x means is that the object is marked as invalid. This doesn't necessarily mean anything is wrong with it.
Whenever you change an object in the database all the objects that reference it are marked as invalid automatically.

So for example, if you change a table, all the views and stored procs that reference that table will be marked as invalid.

To get rid of the x recompile the view.
Re: view problem [message #408213 is a reply to message #408211] Mon, 15 June 2009 06:00 Go to previous message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
thank you
Previous Topic: Column headers displayed to full length despite using substr
Next Topic: SQL PLUS problem passing variable
Goto Forum:
  


Current Time: Mon Dec 22 17:10:42 CST 2014

Total time taken to generate the page: 0.06327 seconds