RMAN提示符下执行SQL语句(二)

2014-11-24 09:00:56 · 作者: · 浏览: 1
t: begin dbms_lock.sleep(3); end;
e、rman块命令方式执行PL/SQL块
RMAN> run{
2> sql ' begin dbms_lock.sleep(3); end; ';
3> }
sql statement: begin dbms_lock.sleep(3); end;
RMAN> run {
2> sql ' drop tablespace ts1 including contents and datafiles ';
3> }
sql statement: drop tablespace ts1 including contents and datafiles
RMAN> shutdown immediate;
database closed
database dismounted
Oracle instance shut down
f、切换到 系统提示符下
RMAN> host;
robin@SZDB:~> exit
exit
host command complete
RMAN>