Oracle creates table spaces with users

    /* Description: If the corresponding user and table space already exists, you need to delete the corresponding user and tablespace first and      then re-establish */--delete user xdayweixin cascade;--Delete table space Drop tablespace Weixin_data_temp including contents and Datafiles;drop tablespace weixin_data      including contents and datafiles;-- Creating a temporary tablespace create temporary tablespace weixin_data_temp tempfile ' weixin_data_temp. DBF '        size 500M autoextend on;--creating tablespace Create tablespace weixin_data logging datafile ' Weixin_data. DBF '        size 500M autoextend on;--Create a user and specify the table space create a user xdayweixin        identified by Xdayweixin    default Tablespace weixin_data    Temporary tablespace weixin_data_temp   profile default;--Grant role permissions to users grant connect to Xdayweixin;grant resource to Xdayweixin;--grant DBA to thinkcms;--grant the user system privileges grant unlimited tablespace to xdayweixin;-- Gives the user DBA Authority--grant dba to Xdayweixinexit;

　　

Oracle creates table spaces with users