conn sys/vortex as sysdba;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
Alter database character set INTERNAL_USE WE8MSWIN1252;
SHUTDOWN IMMEDIATE;
STARTUP;

prompt Configurando ...
ALTER SYSTEM SET open_cursors=3000 SCOPE=spfile;
ALTER SYSTEM SET optimizer_mode=RULE SCOPE=spfile;
ALTER SYSTEM SET processes=150 SCOPE=spfile;
ALTER SYSTEM SET sessions=170 SCOPE=spfile;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=4;
alter system set deferred_segment_creation=FALSE SCOPE=spfile;
alter system set sec_case_sensitive_logon=false SCOPE=spfile;

prompt Criando Tablespace ...
CREATE SMALLFILE TABLESPACE ODIN
DATAFILE 'D:\oracle\app\oracle\oradata\XE\odin01.dbf' SIZE 1G
AUTOEXTEND ON NEXT 10M MAXSIZE
UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT
SPACE MANAGEMENT AUTO;

prompt Alterando Users para 2MB ...
ALTER DATABASE DATAFILE 'D:\oracle\app\oracle\oradata\XE\USERS.DBF' RESIZE 5M;

prompt Criando Usuario Odin ...

create user &&NomeBase
  identified by vtx4753
  default tablespace ODIN
  temporary tablespace TEMP
  profile DEFAULT;

grant connect to &&NomeBase;
grant dba to &&NomeBase;
grant resource to &&NomeBase;
grant unlimited tablespace to &&NomeBase;
GRANT ALTER ANY PROCEDURE TO &&NomeBase;
GRANT ALTER ANY TRIGGER TO &&NomeBase;
GRANT ALTER ANY table TO &&NomeBase;
GRANT ANALYZE ANY TO &&NomeBase;
GRANT CREATE ANY SEQUENCE TO &&NomeBase;
GRANT CREATE ANY TABLE TO &&NomeBase;
GRANT CREATE ANY VIEW TO &&NomeBase;
GRANT CREATE SYNONYM TO &&NomeBase;
GRANT CREATE TRIGGER TO &&NomeBase;
GRANT DELETE ANY TABLE TO &&NomeBase;
GRANT DROP ANY SEQUENCE TO &&NomeBase;
GRANT DROP ANY TABLE TO &&NomeBase;
GRANT EXECUTE ANY PROCEDURE TO &&NomeBase;
GRANT INSERT ANY TABLE TO &&NomeBase;
GRANT SELECT ANY DICTIONARY TO &&NomeBase;
GRANT SELECT ANY SEQUENCE TO &&NomeBase;
GRANT SELECT ANY TABLE TO &&NomeBase;
GRANT UNLIMITED TABLESPACE TO &&NomeBase;
GRANT UPDATE ANY TABLE TO &&NomeBase;


ALTER PROFILE default LIMIT
   FAILED_LOGIN_ATTEMPTS 1000;
alter profile default limit 
   password_life_time unlimited;

GRANT EXECUTE ON UTL_FILE TO PUBLIC;
GRANT EXECUTE ON UTL_SMTP TO PUBLIC;
GRANT EXECUTE ON CTX_DDL TO PUBLIC;
GRANT EXECUTE ON DBMS_CRYPTO TO PUBLIC;
GRANT EXECUTE ON DBMS_LOCK TO PUBLIC;
GRANT EXECUTE ON DBMS_IJOB TO PUBLIC;
GRANT EXECUTE ON DBMS_NETWORK_ACL_ADMIN TO PUBLIC;

SHUTDOWN IMMEDIATE;
STARTUP;


exit