Make sure the database you are using meet the requirements described in Compatible databases.
Procedure
Log in to an existing database.
$ sqlplus SYS@<DB-NAME> AS SYSDBA
Create a user MM and a database
MM with the following privileges.
-- Delete previous user and database if needed
DROP USER MM CASCADE;
CREATE USER MM IDENTIFIED BY MM123!;
GRANT CONNECT TO MM;
GRANT CREATE TABLE TO MM;
GRANT CREATE VIEW TO MM;
GRANT CREATE SEQUENCE TO MM;
GRANT CREATE TRIGGER TO MM;
GRANT CREATE PROCEDURE TO MM;
GRANT CREATE TYPE TO MM;
GRANT EXECUTE ON DBMS_LOB TO MM;
-- If you get the error "Database exception occurred: ORA-01950: no privileges on tablespace 'USERS'"
ALTER USER MM QUOTA UNLIMITED ON USERS;
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
