Create and delete tablespaces and users in oracle in Linux

In Linux, create and delete tablespaces and users in oracle # su-oracle $ sqlplus/nolog SQL> connect/as sysdba -- // create temporary tablespaces create temporary tablespace test_temp tempfile '/data/oracle /oradata/test/test_temp01.dbf '-- // file system size 64 m autoextend on next 64 m maxsize 2048 m extent management local in Linux; -- // create a data table space create tablespace test_data logging datafile '/data/oracle/oradata/test/test_data01.dbf' -- // file system size in Linux 64 m auto Extend on next 65 m maxsize 2048 m extent management local; -- // create a user and specify the table space username and password as "test" create user test identified by test default tablespace test_data temporary tablespace test_temp; -- // grant the user the permission to grant connect, resource to test; -- // Delete the tablespace drop tablespace test_temp including CONTENTS and datafiles; -- // modify the user Password alter user test identified by new_password; -- // Delete the user drop user Username cascade; -- // be careful when executing this statement. Cascade delete all objects under the 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;