-----------Case one: Create table spaces and users
/* 1th step: Create temporary table space/*
Create temporary tablespace ivms86x0_temp----test successfully. Note: The table space name can not be repeated, even if the storage location is inconsistent, but the DBF file is consistent
Tempfile ' I:\oracle\oradata\oracle11g\IVMS86X0_TEMP.dbf '
Size 50m---50m for tablespace sizes, recommended for large data volume 20G, even 32G
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
/* 2nd step: Create a datasheet space/*
Create tablespace ivms86x0_data----test successfully.
Logging
DataFile ' I:\oracle\oradata\oracle11g\IVMS86X0_DATA.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
/* 3rd step: Create user and specify Tablespace/
Create user IVMS86X0_WJ identified by IVMS86X0_WJ---test succeeded.
Default Tablespace ivms86x0_data
Temporary tablespace ivms86x0_temp;
/* 4th step: Granting user permission
--grant Connect,resource to IVMS86X0_WJ; ---test was successful.
Grant CONNECT,RESOURCE,DBA to IVMS86X0_WJ; -----Create permissions before you can connect the test successfully.
/* Delete table space and user/*
Drop user IVMS86X0_WJ cascade; ---Remove all objects from the user successfully in the delete user test.
--drop tablespace yuanmin_data including contents;
--drop tablespace yuanmin_temp including contents;
Drop tablespace ivms86x0_data including contents and datafiles deletes tablespace-----, including file test success.
Drop tablespace ivms86x0_temp including contents and datafiles deletes tablespace-----, including file test success.
-----Delete User tablespace and delete user, there is no successive test success.
----Experience Summary ...
----There is a situation
-A user is in use when performing the drop tablespace ivms86x0_data including contents and datafiles, causing the drop user IVMS86X0_WJ cascade to
--execution, and the corresponding table space file can not be deleted at this time, disconnect the IVMS86X0_WJ user, you can manually delete the table space file
----Case TWO: Specify Tablespace for table index
--STEP0: Create Tablespace P201507
Create tablespace P201507----test successfully.
Logging
DataFile ' I:\oracle\oradata\oracle11g\P201507.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
--STEP2: Create an index and specify the table space
CREATE INDEX Idx_vehiclepass_com3
On Traffic_vehicle_pass (Plate_no, Pass_time, crossing_id) tablespace P201507; --Specify Tablespace for index
-----Case Three: Modify the size of the table space after the Oracle tablespace (data file) is full
1, expand the table space
ALTER DATABASE DataFile ' D:\ORACLE\PRODUCT\ORADATA\TEST\USERS01. DBF ' resize 50m;
2, automatic growth
ALTER DATABASE DataFile ' D:\ORACLE\PRODUCT\ORADATA\TEST\USERS01. DBF ' autoextend on next 50m maxsize 500m;
3. Add data files
Alter tablespace yourtablespacename add datafile ' d:\newtablespacefile.dbf ' size 5m;