重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 单行函数嵌套的实际使用例子 [打印本页]

作者: 郑全 时间: 2014-2-23 16:51
标题: 单行函数嵌套的实际使用例子

select 'alter tablespace ' || tablespace_name || ' begin backup;' || chr(13) || chr(10)
|| 'host cp ''' || file_name || '''' || chr(13) || chr(10)
|| '''/home/oracle/' || substr(file_name,instr(file_name,'/',-1)+1) || '''' || chr(13) || chr(10)
|| 'alter tablespace ' || tablespace_name || ' end backup;'
from dba_DATA_files

'ALTERTABLESPACE'||TABLESPACE_NAME||'BEGINBACKUP;'||CHR(13)||CHR(10)||'HOSTCP'''
--------------------------------------------------------------------------------
alter tablespace USERS begin backup;
host cp '/u01/app/oracle/oradata/sztech1/users01.dbf'
'/home/oracle/users01.dbf'
alter tablespace USERS end backup;

alter tablespace UNDOTBS1 begin backup;
host cp '/u01/app/oracle/oradata/sztech1/undotbs01.dbf'
'/home/oracle/undotbs01.dbf'
alter tablespace UNDOTBS1 end backup;

alter tablespace SYSAUX begin backup;
host cp '/u01/app/oracle/oradata/sztech1/sysaux01.dbf'
'/home/oracle/sysaux01.dbf'
alter tablespace SYSAUX end backup;

alter tablespace SYSTEM begin backup;
host cp '/u01/app/oracle/oradata/sztech1/system01.dbf'
'/home/oracle/system01.dbf'
alter tablespace SYSTEM end backup;

alter tablespace EXAMPLE begin backup;
host cp '/u01/app/oracle/oradata/sztech1/example01.dbf'
'/home/oracle/example01.dbf'
alter tablespace EXAMPLE end backup;

SQL>

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)