updating views in Oracle 8

[MarkElls]

I have three views that are linked to some base tables. I have updated the base tables. Now there appears to be no triggers to update the views and all attempts at doing this have failed as I am reasonably new to Oracle.

If I use TOAD to
select text from user_views
where view_name like '%CGA%'

then all I see is the first line of the text which is the statement that builds the view.

Any suggestions?

 

[SantaMufasa]

Mark,

First, when you update data in base tables, the views automatically reflect the changes, since views are simply "named SELECTs". Nothing needs to occur to "update" the views except for the obligatory "COMMIT" (for others to see the changes).

Next, the "TEXT" column you are trying to acces from USER_VIEWS is a of data type "LONG". Typically, the default display length of a LONG column (in SQL*Plus, for example) is only 80 characters. Therefore, you must specify a much longer display length for LONGs. In SQL*Plus, a command to change the display length from 80 characters to 50,000 is:

SET LONG 50000

Try these suggestions and let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
@ 15:53 (15Nov04) UTC (aka "GMT" and "Zulu"),
@ 08:53 (15Nov04) Mountain Time

 

[MarkElls]

thanks for that.

I can now see the text and have done create or replace to recreate the view. I will now start to see if I can build the OLAP cube from the view which is the end target.

Cheers for that.
Mark.