/*Note: If you already have the appropriate user and table space, you will need to delete the appropriate user and tablespace before re-establishing all*/--Delete UserDrop UserXnzqweixinCascade;--Delete Table SpaceDropTablespace thinkweixin_data_temp including contents anddatafiles;DropTablespace Thinkweixin_data including contents anddatafiles;--Create a temporary table spaceCreate TemporaryTablespace thinkweixin_data_temp Tempfile'thinkweixin_data_temp. DBF'size 500M autoextend on;--CREATE TABLE SpaceCreateTablespace thinkweixin_data Logging DataFile'Thinkweixin_data. DBF'size 500M autoextend on;--Create a user and specify a tablespaceCreate UserXnzqweixin identified byxnzqweixindefaulttablespace thinkweixin_dataTemporarytablespace thinkweixin_data_temp profiledefault;--grant a user permissions to a roleGrantConnect toxnzqweixin;GrantResource toxnzqweixin;GrantDba toxnzqweixin;--granting system permissions to usersGrantUnlimited tablespace toxnzqweixin;Exit;
Oracle creates table spaces with users