CRIAR TABLESPACE E USUÁRIO ORACLE 10G

CREATE TABLESPACE meutablespace LOGGING DATAFILE ‘/oracle10/oradata/minhabase/meutablespace.dbf‘ SIZE 32m AUTOEXTEND ON NEXT 32m EXTENT MANAGEMENT LOCAL;


CREATE USER meuusuario IDENTIFIED BY minhasenha DEFAULT TABLESPACE MEUTABLESPACE QUOTA UNLIMITED ON  MEUTABLESPACE;

GRANT create session, alter session, select_catalog_role, execute_catalog_role, create table, create procedure, create view, create materialized view, create trigger, create sequence, create any directory, create type, create synonym, administer database trigger TO meuusuario;