delete obj$

///
///要用system,dba身份登入进去
///
///
select * from obj$ o
WHERE o.obj#=149554
where o.name='MV_ZD_QLR'

delete from obj$ o
WHERE o.obj#=149554

alter system checkpoint;
alter system flush shared_pool;

 

转载于:https://www.cnblogs.com/hoperboy/p/5163898.html