我正在使用以下C#代码来压缩文件:
// Open the stream we want to compress
FileStream fs = File.Create(@"C:\Projects\Samples\test\compressed.zip", 0);
// Creates the GZipStream
GZipStream gzip = new GZipStream(fs, CompressionMode.Compress);
// Reading the content to compress
byte[] bytes = File.ReadAllByte
Oracle数据库上的存档目标和db_recovery_file_dest之间的确切区别是什么?
SQL> show parameter reco
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
db_recovery_file_dest
主要目标:我想把小块的记录从“工作”表移到存档。
准备:
create table working_tmp as select * from all_objects;
create table archive_tmp as select * from all_objects where 1=2;
计划:
从working_tmp中删除记录到集合中。
将集合插入archive_tmp中。
第一次尝试:
declare
type t_arr is table of working_tmp%rowtype;
v_data t_arr;
begin
delete