Attachment 614966 Details for Bug 859131 – copyfile.sql

copyfile.sql

ora-copyfile-procedure.txt (text/plain), 2.00 KB, created by Johan Bergström on 2012-09-20 15:47:28 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Johan Bergström

Created: 2012-09-20 15:47:28 UTC

Size: 2.00 KB

patch

obsolete

>CREATE OR REPLACE DIRECTORY "RECFILES" AS '/u03/CIFS/OUT/REC';
>
>set serveroutput on
>DECLARE
>   v_exists    BOOLEAN;
>   v_length    NUMBER;
>   v_blocksize NUMBER;
>BEGIN
>  UTL_FILE.FCOPY('RECFILES', 'RecFile_local.xml', 'RECFILES', 'RecFile.xml.tst');
>  UTL_FILE.FGETATTR('RECFILES', 'RecFile_local.xml', v_exists, v_length, v_blocksize);
>  IF v_exists THEN
>      dbms_output.put_line('Source Length is: '||v_length);
>      dbms_output.put_line('Source Block size is: '||v_blocksize);
>  ELSE
>    dbms_output.put_line('File not found.');
>  END IF;
>  UTL_FILE.FGETATTR('RECFILES', 'RecFile.xml.tst', v_exists, v_length, v_blocksize);
>  IF v_exists THEN
>      dbms_output.put_line('Copy Length is: '||v_length);
>      dbms_output.put_line('Copy Block size is: '||v_blocksize);
>  ELSE
>      dbms_output.put_line('File not found.');
>  END IF;
>END;
>/
>
>killed after 2 hours...
>
>-------------------------------------------------------------------------------------------
>
>CREATE OR REPLACE DIRECTORY "RECFILES" AS '/tmp';
>
>set serveroutput on
>DECLARE
>   v_exists    BOOLEAN;
>   v_length    NUMBER;
>   v_blocksize NUMBER;
>BEGIN
>  UTL_FILE.FCOPY('RECFILES', 'RecFile.xml', 'RECFILES', 'RecFile.xml.tst');
>  UTL_FILE.FGETATTR('RECFILES', 'RecFile.xml', v_exists, v_length, v_blocksize);
>  IF v_exists THEN
>      dbms_output.put_line('Source Length is: '||v_length);
>      dbms_output.put_line('Source Block size is: '||v_blocksize);
>  ELSE
>    dbms_output.put_line('File not found.');
>  END IF;
>  UTL_FILE.FGETATTR('RECFILES', 'RecFile.xml.tst', v_exists, v_length, v_blocksize);
>  IF v_exists THEN
>      dbms_output.put_line('Copy Length is: '||v_length);
>      dbms_output.put_line('Copy Block size is: '||v_blocksize);
>  ELSE
>      dbms_output.put_line('File not found.');
>  END IF;
>END;
>/
>
>Source Length is: 462984557
>Source Block size is: 4096
>Copy Length is: 462984557
>Copy Block size is: 4096
>
>PL/SQL procedure successfully completed.
>
>Elapsed: 00:00:48.36
>
>Local filesystem ~ 48 seconds.

Actions: View

Attachments on bug 859131: 614966