一个简单的获取备份文件位置的procedure

最新推荐文章于 2021-09-27 10:05:52 发布

zxszcaijin

最新推荐文章于 2021-09-27 10:05:52 发布

阅读量346

点赞数

分类专栏： Oracle 文章标签： table

本文链接：https://blog.csdn.net/zxszcaijin/article/details/5332632

版权

Oracle 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

本文介绍了一个PL/SQL过程，用于获取Oracle数据库的数据文件、控制文件和日志文件的位置。通过查询v$datafile, v$controlfile和v$logfile视图，并使用bulk collect将结果集存储在集合中，然后遍历并打印每个文件路径。" 46869953,4109759,线性判别分析（LDA）详解,"['数据挖掘', '机器学习', '统计学', '特征选择']

摘要由CSDN通过智能技术生成

create or replace procedure getfiles
as
type mytable is table of varchar2(100);
l_files mytable;
l_refc sys_refcursor;
begin
open l_refc for
select name from v$datafile;
fetch l_refc bulk collect into l_files
for i in 1..l_files.count loop
dbms_output.put_line('datafile'||i||':'||l_files(i));
end loop;
open l_refc for
select name from v$controlfile;
fetch l_refc bulk collect into l_files;
for i in 1..l_files.count loop
dbms_output.put_line('controlfile'||i||':'||l_files(i));
end loop;
open l_refc for
select member from v$logfile;
fetch l_refc bulk collect into l_files;
close l_refc;
for i in 1..l_files.count loop
dbms_output.put_line('logfile'||i||':'||l_files(i));
end loop;

end;

SQL> exec getfiles;
datafile1:E:/APP/XIAOCAI/ORADATA/XIAOCAI/SYSTEM01.DBF
datafile2:E:/APP/XIAOCAI/ORADATA/XIAOCAI/SYSAUX01.DBF
datafile3:E:/APP/XIAOCAI/ORADATA/XIAOCAI/UNDOTBS01.DBF
datafile4:E:/APP/XIAOCAI/ORADATA/XIAOCAI/USERS01.DBF
controlfile1:E:/APP/XIAOCAI/ORADATA/XIAOCAI/CONTROL01.CTL
controlfile2:E:/APP/XIAOCAI/ORADATA/XIAOCAI/CONTROL02.CTL
controlfile3:E:/APP/XIAOCAI/ORADATA/XIAOCAI/CONTROL03.CTL
logfile1:E:/APP/XIAOCAI/ORADATA/XIAOCAI/REDO03.LOG
logfile2:E:/APP/XIAOCAI/ORADATA/XIAOCAI/REDO02.LOG
logfile3:E:/APP/XIAOCAI/ORADATA/XIAOCAI/REDO01.LOG