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;
彪悍的人生不需要解释,彪悍的代码不需要注释。