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.