Note:
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.
/* Divided into four steps */
/* Step 2: create a temporary tablespace */
Copy codeThe Code is as follows:
Create temporary tablespace user_temp
Tempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local;
/* Step 2: create a data table space */
Copy codeThe Code is as follows:
Create tablespace user_data
Logging
Datafile 'd: \ oracle \ oradata \ Oracle9i \ user_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 */
Copy codeThe Code is as follows:
Create user username identified by password
Default tablespace user_data
Temporary tablespace user_temp;
/* Step 4: grant permissions to users */
Copy codeThe Code is as follows:
Grant connect, resource, dba to username;