Oracle creates temporary tablespace, user tablespace, create User association table space, authorization, etc.

1. Create a temporary table space

CREATE Temporary tablespace test_temp

Tempfile ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf '

SIZE 32M

Autoextend on

NEXT 32M MAXSIZE 2048M

EXTENT MANAGEMENT LOCAL;

Generally starting from the second step, you can

2. Create User table Space

CREATE tablespace Gzjssapce

LOGGING

DataFile ' E:\oracle\product\10.2.0\oradata\orcl\gzjs. DBF '

SIZE 32M

Autoextend on

NEXT 32M MAXSIZE 2048M

EXTENT MANAGEMENT LOCAL;

3. Create a user and make a table space

CREATE USER Gzjs identified by password

DEFAULT tablespace Gzjssapce

4, to the user authorization

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 no VIEW, drop any INDEX, drop any PROCEDURE,

SELECT any table, INSERT any table, UPDATE all table, DELETE any table

to Gzjs;

5. Prevent the current user from taking over the table space

Alter user GZJS quota unlimited on users;

6. Grant DBA Authority

Grant CONNECT,RESOURCE,DBA to Gzjs;

7. Note: When importing DBA authority exported database files, be sure to give new users DBA authority to successfully import

Oracle creates temporary tablespace, user tablespace, create User association table space, authorization, etc.