oracle数据库创建表空间,用户及赋权限及常用sql语句

创建表空间

create tablespace tablespace_gsscjdj
logging
datafile 'D:\app\Administrator\oradata\gsscjdj\tablespace_gsscjdj.dbf'
size 2G
autoextend on
next 2G maxsize 10G
extent management local;

 创建用户

create user username identified by password
default tablespace tablespace_gsscjdj;

赋予用户基本权限 

 grant connect, resource to GSSCJDJ;
GRANT 
　　CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
　　ALTER ANY TABLE, ALTER ANY PROCEDURE,
　　DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
　　SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
　　TO GSSCJDJ

查询该用户空间下所有表名和表中记录数

select t.table_name,"NVL"(t.num_rows, 0) "rows" from user_tables t ORDER BY "rows" desc