--create the tablespacecreate smallfile tablespace "Table_container"--Create TABLE space datafile ' E:\ORACLE\ORADATA\ORCL\table_ 01.DBF '--Create data file, file location of data file size 100M--Initial size of data file autoextend on NEXT 100M--data file increment size MAXSIZE UNLIMITED--Data file size Unlimited logging EX TENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT auto--Create the user create username test01--created users identified by "123"--Password Default tablespace table_container--to specify temporary tablespace temp--Specify cache tablespace profile default;--Grant/revoke Object pr Ivileges Grant Select on STUDENT to test01;--grants permission to an existing object--grant/revoke role Privileges Grant connect to test01;--granted to the linked database Permission Grant DBA to test01; --Grant DBA authority---Grant/revoke System Privileges Grant unlimited tablespace to test;--grant the systems permission--Create the tablecreate TABLE Stud ent01--Create a table (s_id varchar2 () NOT null,--non-null constraint s_name VARCHAR2, s_age number (3), CONSTRAINT p k_id PRIMARY Key (s_id),--PRIMARY KEY constraint specifies the constraint name CONSTRAINT ck_age CHECK (S_age > S_age <)--check constraint);--note after the end of the statement End of semicolon
Oracle database tablespace data file user and table-created SQL code