--Create TABLE space and database files and default tablespace size
Create tablespace tablespace_test datafile ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DataBase_Test.DBF ' size 200m;
--Set up automatic database growth
ALTER DATABASE datafile ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DataBase_Test.DBF ' autoextend on;
--Create User
Create user user_test identified by password_test default tablespace tablespace_test account unlock;
--Authorization to the user
Grant Create Table,create View,create trigger, create sequence,create procedure to user_test;
Grant DBA to User_test;
--Modify Table space size
ALTER DATABASE datafile ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DataBase_Test.DBF ' resize 500m;
---************* after importing the database (DMP) tablespace incorrect workaround ************************
Revoke unlimited tablespace from User_test
Alter user user_test default Tablespace tablespace_test
Alter user user_test quota unlimited on tablespace_test
Alter user user_test quota 0 on system
---**************************************************************************
Oracle CREATE database, table user, and permission settings code