一、Oracle创建数据库:
1.1建表空间操作:
1.1.1创建表空间:create tablespace test_space datafile 'D://oracle/test.dbf' size 500M autoextends on next 50M maxsize 5000M;
1.1.2删除表空间:drop tablespace test_space including contents and datafiles;
1.1.3查看表空间:select * from dba_tablespaces,dba_data_files;
1.2.操作用户:
1.2.1创建用户:
create user test001 identified by '密码' default tablespace test_space;
1.2.2授权用户:
alter user test001 quota unlimited on test_space;授权用户test001使用test_space表空间
grant create session to test001;授予test001用户创建session的权限,即登录权限
grant unlimited tablespace to test001;授权test001使用表空间的权限
1.2.3查看用户权限:
select * from user_sys_privs;查看当前用户所有权限
select * from user_tab_privs;查看所用用户对表的权限