Oracle tablespace, user, authorization management

1. query Table Space Location

SELECT * from Dba_data_files;

-d:\app\administrator\oradata\orcl\***.dbf

2. View Temporary tablespace locations

SELECT * FROM V$tempfile

-d:\app\administrator\oradata\orcl\***_tmp.dbf

3. Create a temporary table space

Create temporary tablespace icmamp_temp
Tempfile 'd:\app\administrator\oradata\orcl\icmamp_temp.dbf'
Size 100m
Autoextend on
Next 100m maxsize 20480m
Extent management Local;

4. CREATE TABLE Space

Create Tablespace Icmamp
Logging
DataFile 'd:\app\administrator\oradata\orcl\icmamp.dbf'
Size 200m
Autoextend on
Next 200m maxsize 20480m
Extent management Local;

5. Delete Table space

Drop tablespace icmamp_temp including contents and datafiles cascade constraints;

6. Create user and specify table space

Create user Icmamp identified by 123456 default tablespace icmamp temporary tablespace ICM Amp_temp;

7. User authorization

Grant CONNECT,RESOURCE,DBA to Icmamp;

Oracle tablespace, user, authorization management