Shulou(Shulou.com)06/01 Report--

Create temporary tablespaces:

Create temporary tablespace mdm_temp

Tempfile'/ u01qqapp.oracle.tempspace.tempspaceandmdmchangtemp.dbf'

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management local

Create a tablespace:

Create tablespace MDM

Logging

Datafile'/ u01qqappUniqqoracleCharactersTablespace Universe MDM. Dbf'

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management local

Create a user:

Create user mdm identified by mdm_cbpm_root

Default tablespace mdm

Temporary tablespace mdm_temp

Authorize the user:

Grant connect,resource,dba to mdm

Delete user

Drop user mdm cascade

Delete tablespace

Drop tablespace mdm including contents and datafiles

Query tablespace name:

Select tablespace_name from dba_tablespaces

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.