view name

[alexandre]

i'm running oracle 8.1.6.3 on HP-UX , ver 11
I have to alter the view with the name /bio/300000 and
oracle says "view does not exist". Fact is if i issue the select statment view is displayed.
What i have to do in order to compile this view?


Thx
Alexandre

[shawish_sababa]

do you have a view name /bio/300000 ??? check:
select *
from all_views
where view_name = '/bio/300000 '

i thought objects can not be create with names that have "/" in the. i tryed it on 7.3. if i'm wrong, please let me know

[shawish_sababa]

sorry, when you look for objects in all_views then name must be in uppercase, like this

select *
from all_views
where view_name = '/BIO/300000 '