Oracle用户常见操作

1 建立表空间
create tablespace MONITORDATA
datafile 'c:\test555.dbf' size 2048M
default storage(
  initial 500k
  next 500k
  minextents 1
  maxextents unlimited 
  pctincrease 0
);

2 删除表空间
drop tablespace MONITORDATA including contents and datafiles;


2 创建用户

create user cs identified by jabsco default tablespace MONITORDATA;

3 授权
grant resource,connect,dba to cs;


4 导入文件
imp pige/pige@orcl full=y file=D:\File\Myeclipse\OperationPlatform\database\cs20120222.dmp
ignore=y


imp cs/jabsco@orcl full=y file=f:\cs.dmp ignore=y


imp cs/jabsco@orcl126 full=y file=D:\OperateForm.dmp
ignore=y  owner=(cs)


5  
exp pige/pige@orcl file=d:\pipi.dmp owner=cs --full=y


如何查看有哪些用户的命令  授权命令


exp pige/pige@orcl file=d:\pipi1.dmp owner=(pige)






命令方式：
1   


imp pige/pige@orcl full=y file=D:\File\Myeclipse\OperationPlatform\database\cs20120222.dmp
ignore=y




exp pige/pige@orcl file=d:\pipi1.dmp owner=(pige) //owner=(cs) 指代别的用户