始める前に
手順
-
既存のデータベースにログオンします。
sqlplus.exe SYS@<DB-NAME> as SYSDBA
-
次の権限でユーザーMMとデータベースMMを作成します。
-- 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;