|
|
|
|
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 © 2023 Oracle and/or its affiliates. All rights reserved.