SQPLUS “/ as sysdba”
CREATE USER dimas IDENTIFIED BY alamanda;
ALTER USER dimas IDENTIFIED BY alamanda ACCOUNT UNLOCK;
GRANT CREATE ANY DIRECTORY TO dimas;
CREATE OR REPLACE DIRECTORY test_dir AS ‘/u01/app/oracle/oradata/’;
GRANT READ, WRITE ON DIRECTORY test_dir TO dimas;
