drop user BI cascade;
drop user HR cascade;
drop user IX cascade;
drop user OE cascade;
drop user PM cascade;
drop user SH cascade;
drop user HR cascade;
drop user IX cascade;
drop user OE cascade;
drop user PM cascade;
drop user SH cascade;
drop tablespace EXAMPLE including contents and datafiles cascade constraints;