Example: Drop a view
To remove the RD_MEDHIST view from the RDE:
Drop view RD_MEDHIST;
delete from RT_MD_VIEWDICTIONARY where viewname='RD_MEDHIST';
delete from RD_DATADICTIONARY where rd_viewname='RD_MEDHIST';
commit;
To remove the RD_MEDHIST view from the RDE:
Drop view RD_MEDHIST;
delete from RT_MD_VIEWDICTIONARY where viewname='RD_MEDHIST';
delete from RD_DATADICTIONARY where rd_viewname='RD_MEDHIST';
commit;
Copyright © 2022 Oracle and/or its affiliates. All rights reserved.