Following request of Laith Al-Quadah, I am sharing the script which did work in my case (the cleanup and creation of DB user in Oracle for Mendix installation).
DB Cleanup (this will drop ALL objects created by the user):
BEGIN
FOR cur_rec IN (SELECT object_name, object_type
FROM user_objects
WHERE object_type IN
('TABLE',
'VIEW',
'PACKAGE',
'PROCEDURE',
'FUNCTION',
'SEQUENCE',
'SYNONYM',
'PACKAGE BODY'
))
LOOP
BEGIN
IF cur_rec.object_type = 'TABLE'
THEN
EXECUTE IMMEDIATE 'DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '" CASCADE CONSTRAINTS';
ELSE
EXECUTE IMMEDIATE 'DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '"';
END IF;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( 'FAILED: DROP '
|| cur_rec.object_type
|| ' "'
|| cur_rec.object_name
|| '"'
);
END;
END LOOP;
END;
/
Create user:
CREATE USER MENDIX IDENTIFIED BY mendix;
GRANT CREATE SESSION TO MENDIX;
Grant permissions:
GRANT CREATE TABLE TO mendix;
GRANT CREATE SEQUENCE TO mendix;
GRANT UNLIMITED TABLESPACE TO mendix;
GRANT RESOURCE TO mendix;
GRANT SELECT ANY TABLE TO mendix;
GRANT SELECT ON DBA_TABLES TO mendix;
I hope this works for you.
Cheers,
Bart