Shulou(Shulou.com)05/31 Report--

This article mainly introduces Oracle RAC how to create tablespaces and users, the article is very detailed, has a certain reference value, interested friends must read it!

Create a tablespace:

Create tablespace hr6_Data datafile

'+ DATA' size 5000m REUSE

Autoextend on next 10M MAXSIZE Unlimited

Extent management local autoallocate

Permanent

Online

Create temporary tablespaces:

Create temporary tablespace hr6_TempData tempfile

'+ DATA' size 200m REUSE

Autoextend on next 10M MAXSIZE Unlimited

Extent management local uniform size 256K

View the tablespace:

SELECT t.tablespace_name, round (SUM (bytes / (1024 * 1024)), 0) ts_size

FROM dba_tablespaces t, dba_data_files d

WHERE t.tablespace_name = d.tablespace_name

GROUP BY t.tablespace_name

Create a user:

SQL > create user wmwhse6 profile SCEUSER identified by "XXXX"

Default tablespace wmwhse6_Data temporary tablespace wmwhse6_TempData

User created.

SQL > grant connect,resource to wmwhse6

Grant succeeded.

SQL > grant dba to wmwhse6

Grant succeeded.

SQL > create role r_wmwhse6 not identified

Role created.

SQL > grant r_wmwhse6 to wmwhse6

Grant succeeded.

Delete temporary tablespaces:

SQL > DROP TABLESPACE HR6_TEMPDATA INCLUDING CONTENTS AND DATAFILES

Tablespace dropped.

Delete tablespaces:

SQL > DROP TABLESPACE HR6_DATA INCLUDING CONTENTS AND DATAFILES

Tablespace dropped.

These are all the contents of the article "how Oracle RAC creates tablespaces and users". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.