Home » SQL & PL/SQL » SQL & PL/SQL » problem with dbms_file_transer (10.0.2.4 , Windows 2003 Server)
problem with dbms_file_transer [message #425018] Wed, 07 October 2009 03:28 Go to next message
Draco
Messages: 6
Registered: March 2006
Location: Germany/Duesseldorf
Junior Member
Hi,

I try to use dbms_file_transfer.put_file to move a db-export file.
The file arrives at the target Server , but the size changed to 4 kb Shocked . It seems that oracle transfers the first block , only.
Stupidly Oracle donĀ“t throw an exception.

Someone an idea , whats the problem ?

Thanks , and many greetings Wink


hmmmm
Re: problem with dbms_file_transer [message #425022 is a reply to message #425018] Wed, 07 October 2009 03:37 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member

Hi,

Check the space in the file system ..

Regards

Bala
Re: problem with dbms_file_transer [message #425031 is a reply to message #425018] Wed, 07 October 2009 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post your code.

Regards
Michel
Re: problem with dbms_file_transer [message #425047 is a reply to message #425031] Wed, 07 October 2009 05:24 Go to previous message
Draco
Messages: 6
Registered: March 2006
Location: Germany/Duesseldorf
Junior Member
@Bala , i checked the space , >4 gb free = much more than neccesary

Quote:
Post your code.

Regards
Michel




.
.
act_job_name  := v_schema || '_' || to_char(sysdate, 'ddmonyyyy_hh24miss');
		v_dph := DBMS_DATAPUMP.open(operation=>'EXPORT',job_mode=>'SCHEMA',job_name=> act_job_name);
		v_filename := v_schema ||'_'|| to_char(sysdate, 'dd-mon-yyyy_hh24:mi:ss');
DBMS_DATAPUMP.add_file(handle=>v_dph,filename=>v_filename || '.DMP',directory =>v_source_directory_obj,filetype=>1);
DBMS_DATAPUMP.add_file(handle=>v_dph,filename=>v_filename || '.LOG',directory => v_source_directory_obj,filetype=>3);
DBMS_DATAPUMP.metadata_filter(handle => v_dph,name=>'SCHEMA_EXPR',value=> 'IN (''usr_sdok'')');
DBMS_DATAPUMP.start_job(v_dph);
DBMS_DATAPUMP.detach(v_dph);
-- send data
transport_data (v_source_directory_obj ,v_destination_directory_obj, v_remote_database_link,v_filename || '.DMP');
.
.


procedure transport_data (v_source_directory_obj VARCHAR2,v_destination_directory_obj VARCHAR2, v_remote_database_link VARCHAR2,v_filename VARCHAR2)
	  is
	  begin
	  	DBMS_FILE_TRANSFER.PUT_FILE(v_source_directory_obj,v_filename,v_destination_directory_obj,v_filename,v_remote_database_link );
	  end;
	  	

[Updated on: Wed, 07 October 2009 05:26]

Report message to a moderator

Previous Topic: Update statement from 2 table with copied value (merged)
Next Topic: Problem with getting IP address ....
Goto Forum:
  


Current Time: Tue Sep 27 09:22:39 CDT 2016

Total time taken to generate the page: 0.08726 seconds