Create Table spaces and users in Oracle and create tables in oracle

Create Table spaces and users in Oracle and create tables in oracle

User name: C # NEWO

========================================================== ============================================

/* Divided into four steps */

/* Step 2: create a temporary tablespace */

Create temporary tablespace C # NEWO_TEMP

Tempfile 'e: \ OracleTableSpace \ NEWO \ C # newo_temp.dbf'

Size 50 m

Autoextend on

Next 50 m maxsize 20480 m

Extent management local;

 

/* Step 2: create a data table space */

Create tablespace C # NEWO_DATA

Logging

Datafile 'e: \ OracleTableSpace \ NEWO \ C # newo_data.dbf'

Size 50 m

Autoextend on

Next 50 m maxsize 20480 m

Extent management local;

 

/* Step 2: create a user and specify the tablespace */

Create user C # NEWO identified by root

Default tablespace C # NEWO_DATA

Temporary tablespace C # NEWO_TEMP;

 

/* Step 4: grant permissions to users */

Grant connect, resource, dba to C # NEWO;

========================================================== ==================================

 

Others

1. If you open it in PL/SQL or other tools, directly modify the [italic bold part] in the following code to execute

2. Make sure that the path exists, for example, [D: \ oracle \ oradata \ Oracle9i \], that is, the path of the file to be saved exists.

-- Create the user

Create user USER2 -- username identified by password -- password
Default tablespace USERS -- default tablespace
Temporary tablespace TEMP -- temporary tablespace
Input SQL statement:

-- Grant/Revoke role privileges grant connect to USER2; grant resource to USER2;

Grant permissions to users and execute the statement by pressing F8

The oracle12c user must start with c #.

Obtain 【]