Summary of creating temporary tablespace, user tablespace, creating user-associated tablespace, and authorization in oracle

Summary of creating temporary tablespace, user tablespace, creating user-associated tablespace, and authorization in oracle
1. Create a temporary tablespace

Create temporary tablespace test_temp
TEMPFILE 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl \ test_temp01.dbf'
SIZE 32 M
AUTOEXTEND ON
NEXT 32 m maxsize 2048 M
Extent management local;

Generally, you can start from step 2.

2. Create a user tablespace

Create tablespace gzjssapce
LOGGING
DATAFILE 'e: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ gzjs. dbf'
SIZE 32 M
AUTOEXTEND ON
NEXT 32 m maxsize 2048 M
Extent management local;

3. Create a user and create a tablespace
Create user gzjs identified by password
Default tablespace gzjssapce

4. Authorize the user
Grant create session, create any table, create any view, create any index, create any procedure,
Alter any table, alter any procedure,
Drop any table, drop any view, drop any index, drop any procedure,
Select any table, insert any table, update any table, DELETE ANY TABLE
TO gzjs;
5. Prevent the current user from occupying the tablespace excessively
Alter user gzjs quota unlimited on users;

6. Grant DBA Permissions

Grant connect, resource, dba to gzjs;

7. Note: You must grant the DBA permission to the new user before importing the exported database file.