记录一些 Oracle 操作命令

su - oraclesqlplus / as sysdba

create tablespace newts datafile '/xxx/orcl/newts.dbf' size 100m autoextend on next 32m maxsize 32G;

create user newusername identified by newuserpasswd default tablespace newts;

给用户（newusername）授权dba权限grant dba to newusername;授权用户有创建job的权限grant create job to newusername;授予用户管理scheduler权限grant manage scheduler to newusername;授权用户创建表的权限grant create any table to newusername;

删除用户（newusername）及用户下东西drop user newusername cascade;

DROP TABLESPACE newts INCLUDING CONTENTS AND DATAFILES;

exp username/userpasswd@orcl file=dataxxx220221.dmp

imp newusername/newuserpasswd@orcl file=dataxxx220221.dmp tablespaces=newts fromuser=username touser=newusername