Para criar um usuário no Oracle utilizando um tablespace sem limite de espaço, com o nome meuusuario e senha minhasenha com alguns privilégios básicos para conseguir logar, criar e apagar tabelas e outros objetos execute:
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;
Observações: Eu testei estes comandos no Oracle 10G.
And now in english:
To create a user in Oracle with an unlimited tablespace, with username myuser, password mypass and with the basic privileges in order to login, create and remove tables and some other objects run:
CREATE TABLESPACE mytablespace LOGGING DATAFILE ‘/oracle10/oradata/mybase/myablespace.dbf‘ SIZE 32m AUTOEXTEND ON NEXT 32m EXTENT MANAGEMENT LOCAL;
CREATE USER myuser IDENTIFIED BY mypass DEFAULT TABLESPACE mytablespace QUOTA UNLIMITED ON mytablespace;
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 myuser;
Note: I’d tested this on Oracle 10G
