Oracle用户常见操作

来源：互联网发布：微电影剪辑软件编辑：程序博客网时间：2024/04/30 22:32

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) 指代别的用户