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 【]