[20130803]ORACLE 12C RMAN 功能增強.txt

[20130803]ORACLE 12C RMAN 功能增強.txt

在oracle 12c rman中可以直接輸入sql語句，缺點就是僅僅輸出最大僅僅80列，不知道如何調整。

d:\tmp>rman target sys/xxxx@test01p

Recovery Manager: Release 12.1.0.1.0 - Production on Fri Aug 2 22:53:49 2013

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TEST (DBID=2119378787)

RMAN> select * from scott.emp;

using target database control file instead of recovery catalog
     EMPNO ENAME      JOB              MGR HIREDATE                   SAL
---------- ---------- --------- ---------- ------------------- ----------
      COMM     DEPTNO
---------- ----------
      7369 SMITH      CLERK           7902 1980-12-17 00:00:00        800
                   20

      7499 ALLEN      SALESMAN        7698 1981-02-20 00:00:00       1600
       300         30

      7521 WARD       SALESMAN        7698 1981-02-22 00:00:00       1250
       500         30

      7566 JONES      MANAGER         7839 1981-04-02 00:00:00       2975
                   20

      7654 MARTIN     SALESMAN        7698 1981-09-28 00:00:00       1250
      1400         30

      7698 BLAKE      MANAGER         7839 1981-05-01 00:00:00       2850
                   30