-- Generated by Oracle SQL Developer Data Modeler 4.0.1.836
--   at:        2015-02-06 10:24:47 GMT
--   site:      Oracle Database 11g
--   type:      Oracle Database 11g




DROP VIEW ALL_ORDS_CLIENT_PRIVILEGES 
;

DROP VIEW ALL_ORDS_CLIENT_ROLES 
;

DROP VIEW ALL_ORDS_HANDLERS 
;

DROP VIEW ALL_ORDS_MODULES 
;

DROP VIEW ALL_ORDS_OBJECTS 
;

DROP VIEW ALL_ORDS_OBJ_MEMBERS 
;

DROP VIEW ALL_ORDS_PARAMETERS 
;

DROP VIEW ALL_ORDS_PENDING_APPROVALS 
;

DROP VIEW ALL_ORDS_PRIVILEGES 
;

DROP VIEW ALL_ORDS_PRIVILEGE_MAPPINGS 
;

DROP VIEW ALL_ORDS_PRIVILEGE_MODULES 
;

DROP VIEW ALL_ORDS_PRIVILEGE_ROLES 
;

DROP VIEW ALL_ORDS_ROLES 
;

DROP VIEW ALL_ORDS_SCHEMAS 
;

DROP VIEW ALL_ORDS_SERVICES 
;

DROP VIEW ALL_ORDS_TEMPLATES 
;

DROP VIEW ORDS_REPVERSION 
;

DROP VIEW POOL_CONFIG 
;

DROP VIEW URL_MAPPINGS 
;

DROP VIEW USER_ORDS_APPROVALS 
;

DROP VIEW USER_ORDS_CLIENTS 
;

DROP VIEW USER_ORDS_CLIENT_PRIVILEGES 
;

DROP VIEW USER_ORDS_CLIENT_ROLES 
;

DROP VIEW USER_ORDS_ENABLED_OBJECTS 
;

DROP VIEW USER_ORDS_HANDLERS 
;

DROP VIEW USER_ORDS_MODULES 
;

DROP VIEW USER_ORDS_OBJECTS 
;

DROP VIEW USER_ORDS_OBJ_MEMBERS 
;

DROP VIEW USER_ORDS_PARAMETERS 
;

DROP VIEW USER_ORDS_PENDING_APPROVALS 
;

DROP VIEW USER_ORDS_PRIVILEGES 
;

DROP VIEW USER_ORDS_PRIVILEGE_MAPPINGS 
;

DROP VIEW USER_ORDS_PRIVILEGE_MODULES 
;

DROP VIEW USER_ORDS_PRIVILEGE_ROLES 
;

DROP VIEW USER_ORDS_ROLES 
;

DROP VIEW USER_ORDS_SCHEMAS 
;

DROP VIEW USER_ORDS_SERVICES 
;

DROP VIEW USER_ORDS_TEMPLATES 
;

DROP TABLE oauth_approval_privs CASCADE CONSTRAINTS ;

DROP TABLE oauth_approvals CASCADE CONSTRAINTS ;

DROP TABLE oauth_client_privileges CASCADE CONSTRAINTS ;

DROP TABLE oauth_client_roles CASCADE CONSTRAINTS ;

DROP TABLE oauth_clients CASCADE CONSTRAINTS ;

DROP TABLE oauth_pending_approvals CASCADE CONSTRAINTS ;

DROP TABLE oauth_sessions CASCADE CONSTRAINTS ;

DROP TABLE ords_handlers CASCADE CONSTRAINTS ;

DROP TABLE ords_modules CASCADE CONSTRAINTS ;

DROP TABLE ords_objects CASCADE CONSTRAINTS ;

DROP TABLE ords_parameters CASCADE CONSTRAINTS ;

DROP TABLE ords_schemas CASCADE CONSTRAINTS ;

DROP TABLE ords_templates CASCADE CONSTRAINTS ;

DROP TABLE ords_url_mappings CASCADE CONSTRAINTS ;

DROP TABLE ords_workspace_schemas CASCADE CONSTRAINTS ;

DROP TABLE sec_authenticators CASCADE CONSTRAINTS ;

DROP TABLE sec_keys CASCADE CONSTRAINTS ;

DROP TABLE sec_origins_allowed_modules CASCADE CONSTRAINTS ;

DROP TABLE sec_privilege_auths CASCADE CONSTRAINTS ;

DROP TABLE sec_privilege_mappings CASCADE CONSTRAINTS ;

DROP TABLE sec_privilege_modules CASCADE CONSTRAINTS ;

DROP TABLE sec_privilege_roles CASCADE CONSTRAINTS ;

DROP TABLE sec_privileges CASCADE CONSTRAINTS ;

DROP TABLE sec_role_mappings CASCADE CONSTRAINTS ;

DROP TABLE sec_roles CASCADE CONSTRAINTS ;

DROP TABLE sec_sessions CASCADE CONSTRAINTS ;

