SQL > create tablespace TBLS_DADOS01
2 datafile
3 'c:\oracle\product\10.2.0\oradata\TBLS_DADOS01.dbf' size 100m autoextend on next 50m maxsize 500m
4 online
5 permanent
6 extent management local autoallocate
7 segment space management auto;
Tablespace Created.
SQL > create user USERX
2 identified by USERX
3 default tablespace TBLS_DADOS01
4 temporary tablespace TEMP;
User Created.
SQL > grant create session, create table, create view, create sequence, create procedure, create trigger, create synonym to USERX;
Grant succeeded.
SQL > alter user USERX quota unlimited on TBLS_DADOS01;
User Altered.
SQL > @c:\seuScriptAqui.sql
