我最常用的oracle命令

 

• 创建用户
  create user ... identified by pwd;
• 删除用户
  drop user ... cascade;
• 创建表空间
  create tablespace ts_drp datafile 'd:\drp-date.dbf' size 2000m
• 将表空间分配给用户
  alter user ... default tablespace ts_drp;
• 授权
  grant dba(resource、CONNECT) to user
• 回收权限
  revoke dba(resource、CONNECT) FROM  user
• 修改表空间名称
  alter tablespace ts_surao rename to HEADGMP;
• 导入文件
  imp head/head@orcl file=f:\new.dmp  fromuser=NEWMMSROOT  touser=head ignore=yes
• 注意：导入文件的时候最好确认备份的表空间和新建的表空间名字一样。要不然报好多错误

create user head identified by head;


create tablespace HEADGMP datafile '/u01/oradata/head/head-date.dbf' size 200m AUTOEXTEND ON EXTENT MANAGEMENT LOCAL 


SEGMENT SPACE MANAGEMENT AUTO;


alter user head default tablespace HEADGMP;


grant CONNECT to head;


imp head/head@wilson file=/u01/EXPDAT.DMP  full=y ignore=yes