Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can´t drop materialized view
- Thread starter Barbaro
- Start date
Hi Barbaro
Well then oracle says it can’t find your view – then your telling Oracle to drop an unknowing materialized view.
Try this:
Connect to the database as SYSDBA – or as SYSTEM
select obj.owner, obj.object_name
from dba_objects obj, sys.obj$ s
where s.type# = 42
and obj.object_id = s.obj#;
You now receive a list of materialized views.
Please show the DROP syntax and show the above result.
Regards
Allan
Icq: 346225948
Well then oracle says it can’t find your view – then your telling Oracle to drop an unknowing materialized view.
Try this:
Connect to the database as SYSDBA – or as SYSTEM
select obj.owner, obj.object_name
from dba_objects obj, sys.obj$ s
where s.type# = 42
and obj.object_id = s.obj#;
You now receive a list of materialized views.
Please show the DROP syntax and show the above result.
Regards
Allan
Icq: 346225948
- Status
Similar threads
- Locked
- Question
- Locked
- Question
