Oracle creates table spaces and users

User name is: C # #NEWO

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

/* divided into four steps */

/* Step 1th: Create a temporary tablespace */

Create temporary tablespace C # #NEWO_TEMP

Tempfile ' e:\oracletablespace\newo\c# #NEWO_TEMP. dbf '

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management Local;

/* Step 2nd: Create a data table space */

Create tablespace C # #NEWO_DATA

Logging

DataFile ' e:\oracletablespace\newo\c# #NEWO_DATA. dbf '

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management Local;

/* 3rd step: Create user and specify Tablespace */

Create User C # #NEWO identified by root

Default Tablespace C # #NEWO_DATA

Temporary tablespace C # #NEWO_TEMP;

/* Step 4th: Grant permissions to users */

Grant CONNECT,RESOURCE,DBA to C # #NEWO;

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

Other

1. If it is opened in a tool such as PL/SQL, directly modify the following code [Italic bold section] to execute

2. Ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\", which is the path where you want to save the file

--Create the user

Create user USER2--user name identified by password--password

Default tablespace USERS-Defaults table space

Temporary tablespace Temp--Temporary table space

Enter the SQL statement:

--Grant/revoke role privileges Grant connect to user2;grant resource to USER2;

Give permissions to the user, press F8 to execute the statement

ORACLE12C create user to #开头 in C #

650) this.width=650; "id=" Aimg_ofump "class=" Zoom "width=" "src=" http://gd2.alicdn.com/imgextra/i2/332189337/ Tb2q1occvxxxxchxpxxxxxxxxxx-332189337.png "border=" 0 "style=" Color:rgb (68,68,68); Font-family:tahoma, Helvetica, SimSun, Sans-serif;font-size:14px;line-height:21px;white-space:normal;background-color:rgb (255,255,255); "/>
get ""   

Oracle creates table spaces and users