oracle用户创建

删除用户
sql > drop user cds cascade;

创建临时表空间
sql > create temporary tablespace CDS_TEMP 
tempfile '/u01/app/oracle/oradata/cdsdb/CDS_TEMP.dbf'
size 64m 
autoextend on 
next 64m;

创建数据表空间
sql > create tablespace CDS_DATA
logging
datafile '/u01/app/oracle/oradata/cdsdb/CDS_DATA.dbf'
size 512m 
autoextend on 
next 128m 
extent management local;

创建用户并指定表空间
sql > create user cds identified by password 
default tablespace CDS_DATA temporary tablespace CDS_TEMP;
赋予权限
sql > grant create session ,create any table ,create any view ,create any index,create any procedure ,create any trigger,create any sequence ,alter any table ,alter any procedure,alter any trigger,alter any sequence,select any table ,drop any table ,drop any view ,drop any trigger ,drop any sequence,drop any index,drop any procedure ,insert any table , update any table ,delete any table,unlimited tablespace  to cds;

创建备份目录
# cd /home/oracle/
# mkdir backup

创建数据库导入路径
sql > create or replace directory backup as '/home/oracle/backup/';
将目录授权给需要导入表的用户
sql > grant read,write on directory backup to cds;
查询备份目录
sql > select * from dba_directories;