Oracle数据库基本知识

一、创建表空间

create tablespace SBDSPACE  
datafile 'D:/oracle_tablespaces/SBDSPACE_TBSPACE.dbf'  
size 1500M  
autoextend on next 5M maxsize 3000M;

 

二、创建用户

create user shen identified by "123";

grant create session to shen;  
grant create table to  shen;  
grant create tablespace to  shen;  
grant create view to  shen;

grant dba to  shen;//赋DBA权限

grant connect,resource to shen;  
grant create any sequence to shen;  
grant create any table to shen;  
grant delete any table to shen;  
grant insert any table to shen;  
grant select any table to shen;  
--grant unlimited tablespace to shen;  
grant execute any procedure to shen;  
grant update any table to shen;  
grant create any view to shen;  

三、授予用户使用表空间的权限

 alter user shen quota unlimited on SBDSPACE   

四、Oracle执行Sql脚本

    在命令窗口中输入：@E:\路径\**.sql;