Oracle基本操作

 

--创建表空间
CREATE TABLESPACE CSS
DATAFILE 'F:\oracle\product\10.2.0\oradata\orcl\cssdata.dbf' SIZE 500M
UNIFORM SIZE 128k;

--创建用户
create user cssadmin
identified by "css.2010"
default tablespace CSS
temporary tablespace TEMP
profile DEFAULT;

--授予权限
grant connect to cssadmin;
grant dba to cssadmin;
grant resource to cssadmin;
grant unlimited tablespace to cssadmin;
grant create table to cssadmin;
grant create sequence to cssadmin;
grant create session to cssadmin;

commit;