Oracle创建用户，创建表空间

--1. 使用用户名sys，口令：123456，数据库：ORCL，链接为：SYSDBA 登录pl sql
 
-- Create the user
create user 用户名
  identified by "密码"
  default tablespace 表空间
  temporary tablespace 临时表空间
  profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to 用户名;
grant resource to 用户名;
-- Grant/Revoke system privileges
grant create any job to 用户名 with admin option;
grant create any procedure to 用户名 with admin option;
grant create any view to 用户名;
grant create materialized view to 用户名 with admin option;
grant create public database link to 用户名 with admin option;
grant create session to 用户名 with admin option;
grant create table to 用户名 with admin option;
grant drop any procedure to 用户名 with admin option;
grant execute any procedure to 用户名;
grant insert any table to 用户名;
grant select any table to 用户名 with admin option;
grant unlimited tablespace to 用户名 with admin option;

查询表空间位置 

SELECT file_name，tablespace_name FROM Dba_data_files

-- 正常的表空间
CREATE TABLESPACE 表空间名称 DATAFILE 'E:\app\Lenovo\product\11.2.0\dbhome_1\oradata\表空间名称' SIZE 32M AUTOEXTEND ON NEXT 100M MAXSIZE 6G LOGGING ONLINE EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON;


-- 临时表空间
CREATE TEMPORARY TABLESPACE 表空间名称 TEMPFILE 'E:\app\Lenovo\product\11.2.0\dbhome_1\oradata\表空间名称' SIZE 128M  AUTOEXTEND ON  NEXT 32M MAXSIZE 4096M  EXTENT MANAGEMENT LOCAL;