Oracle : Unlimited Tablespace, User Creation,Tablespace creation

Oracle : Unlimited Tablespace, User Creation


SQL> create user muthu identified by oracle
2 default tablespace users;
User created.
SQL> grant connect to muthu;
Grant succeeded.
SQL> grant create any table to muthu;
Grant succeeded.
SQL> grant create table to muthu;
Grant succeeded.
SQL> grant unlimited tablespace to muthu;
Grant succeeded.

Create table space

SQL>create tablespace data datafile '/home/oracle/databases/ora10/data.dbf' size 30m autoextend on;