主页 / user-205852

lear1's questions

Martin Hope
lear1
Asked: 2020-04-07 01:59:52 +0800 CST
  • 0

我有这个块的 .sh 脚本：

sqlplus -S / as sysdba <<EOFILE

set feedback off
set lines 2000
set pages 20000
col db_size for a15
alter session set nls_date_format = 'DD-MM-YYYY HH24:MI:SS';

select * from ( select "START_TIME", "END_TIME", INPUT_BYTES_DISPLAY db_size from v$RMAN_BACKUP_JOB_DETAILS order by "END_TIME" DESC) where ROWNUM <= 5;

EOFILE

EOF

但输出是这个错误：

select * from ( select "START_TIME", "END_TIME", INPUT_BYTES_DISPLAY db_size from v order by "END_TIME" DESC) where ROWNUM <= 5 * ERROR at line 1: ORA-04044: procedure, function, package, or type is not allowed这里

我知道访问 v$RMAN_BACKUP_JOB_DETAILS 存在问题，但我应该如何解决这个问题？

我试过了：

v\$RMAN_BACKUP_JOB_DETAILS
'v$RMAN_BACKUP_JOB_DETAILS'
"v$RMAN_BACKUP_JOB_DETAILS"

有人能帮我吗？谢谢

oracle scripting