--CREATE table space and database files and default tablespace sizeCreateTablespace tablespace_test datafile'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DataBase_Test.DBF'size 200m;--set up automatic database growthAlter DatabaseDataFile'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DataBase_Test.DBF'Autoextend on;--Create userCreate UserUser_test identified byPassword_testdefaulttablespace tablespace_test account unlock;--authorization to the userGrant Create Table,Create View,Create Trigger,CreateSequenceCreate procedure touser_test;GrantDba touser_test;--Modify table space sizeAlter DatabaseDataFile'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DataBase_Test.DBF'resize 500m;---************* After importing the database (DMP) tablespace incorrect workaround ************************RevokeUnlimited tablespace fromuser_testAlter UserUser_testdefaulttablespace tablespace_testAlter UserUser_test Quota Unlimited ontablespace_testAlter UserUser_test Quota0 onsystem---**************************************************************************
Oracle SQL statements Create tablespace, database, user, and authorization