创建oracle用户和表空间

查看oracle的服务名
select name from v$database;
查看当前的sid
select sid from V$mystat where rownum=1;
//查看当前的sid和连接总数
select sid, serial#, username from v$session where username is not null;
查看启动的流程实例
ps -ef | grep pmon
查看数据库中的用户名和密码
select username,created,password from dba_users;
看看您当前的数据库文件放在哪里的：
select name from v$datafile;
删除表空间
drop tablespace developdf including contents and datafiles;
创建表空间developdf
create tablespace developdf datafile '/u01/app/oradata/orcl/develop.dbf' size 500m autoextend on next 100m maxsize unlimited;
删除用户
drop user develop cascade;
创建用户develop密码develop
create user develop identified by develop default tablespace developdf;
create user develop identified by develop default tablespace developdf;
创建权限
grant dba to develop;
撤销权限
revoke dba from develop;