Oracle CREATE database, table user, and permission settings code

--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