2023年12月15日发(作者：)

SQL> set serveroutput onSQL> declare 2 v_filetype NUMBER; -- 0=unknown 1=expdp 2=exp 3=ext 3 v_info_table $_dumpfile_info; -- PL/SQL table with file info 4 begin 5 dbms__dumpfile_info( 6 filename => '', 7 directory => upper('dhome'), 8 info_table => v_info_table, filetype => v_filetype); 9 dbms__line('Filetype : ' || v_filetype); 10 end; 11 /Filetype : 2SQL> set serveroutput onSQL> declare 2 v_filetype NUMBER; -- 0=unknown 1=expdp 2=exp 3=ext 3 v_info_table $_dumpfile_info; -- PL/SQL table with file info 4 begin 5 dbms__dumpfile_info( 6 filename => '', 7 directory => upper('dhome'), 8 info_table => v_info_table, filetype => v_filetype); 9 dbms__line('Filetype : ' || v_filetype); 10 end; 11 /Filetype : 1PL/SQL procedure successfully > set serveroutput onSQL> declare 2 v_filetype NUMBER; -- 0=unknown 1=expdp 2=exp 3=ext 3 v_info_table $_dumpfile_info; -- PL/SQL table with file info 4 begin 5 dbms__dumpfile_info( 6 filename => '', 7 directory => upper('dhome'), 8 info_table => v_info_table, filetype => v_filetype); 9 dbms__line('Filetype : ' || v_filetype); 10 end; 11 /Filetype : 1PL/SQL procedure successfully > set serveroutput onSQL> declare 2 v_filetype NUMBER; -- 0=unknown 1=expdp 2=exp 3=ext 3 v_info_table $_dumpfile_info; -- PL/SQL table with file info 4 begin 5 dbms__dumpfile_info( 6 filename => '', 7 directory => upper('dhome'), 8 info_table => v_info_table, filetype => v_filetype); 9 dbms__line('Filetype : ' || v_filetype); 10 end; 11 /Filetype : 0PL/SQL procedure successfully completed.

6.数据库字符集，数据库名称，操作系统类型，操作系统名称