-
编辑 删除
快速切换数据文件从裸设备切换到另外一个裸设备上
通过我们可以通过dd来完成这个操作，我们还可以使用rman来操作：[oracle@10g hcl]$ rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Tue Nov 4 13:12:31 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: TEST (DBID=1963002549)RMAN> sql 'alter database datafile 5 offline';using target database control file instead of recovery catalogsql statement: alter database datafile 5 offlineRMAN> backup as copy datafile 5 format '/home/oracle/oradata/tes
-
编辑 删除
理解grant的with admin option
SQL> conn / as sysdba已连接。SQL> grant connect to hcl;授权成功。SQL> conn hcl/hcl已连接。SQL> grant connect to test;grant connect to test*第 1 行出现错误:ORA-01932: ADMIN 选项未授权给角色 'CONNECT'SQL> grant create session to test;grant create session to test*第 1 行出现错误:ORA-01031: 权限不足SQL> conn / as sysdba已连接。SQL> grant connect to hcl with admin option;授权成功。SQL> conn hcl/hcl已连接。SQL> grant create session to test;grant create session to test*第 1 行
