Oracle creates and deletes table spaces and user ____java under Linux environment

#su-oracle
$ sqlplus/nolog
Sql> Connect/as SYSDBA
--//Create temporary table spaces
Create temporary tablespace test_temp
File system under the Tempfile '/data/oracle/oradata/test/test_temp01.dbf '--//linux
Size 64m
Autoextend on
Next 64m maxsize 2048m
Extent management Local;

--//Create a datasheet space
Create Tablespace Test_data
Logging
File system under the DataFile '/data/oracle/oradata/test/test_data01.dbf '--//linux
Size 64m
Autoextend on
Next 65m maxsize 2048m
Extent management Local;

--//create user and specify table space username and password are "test"
Create user test identified by test
Default Tablespace test_data
Temporary tablespace test_temp;


--//Grant permissions to users

Grant Connect,resource to test;

--//Delete Table Space
Drop tablespace test_temp including CONTENTS and datafiles;

--//Modify User Password
Alter user test identified by New_password;

--//Delete User
Drop user username cascade; --//execute the statement, be careful, and cascade the deletion of all objects under that user.


--//Assign permissions to users

Sql> Grant connect to Test_user;
Sql> grant resource to Test_user;
Sql> Grant CREATE view to Test_user;
Sql> GRANT DEBUG CONNECT session to Test_user;
sql> GRANT DEBUG any PROCEDURE to Test_user;