Coordinating (making a certificate) two machines for using SSH (Secure
SHell) or SCP (Secure CoPy) without asking for a password is not
difficult, but its a little bit tricky and requires having the most
recent versions of the OS in both machines.
The solution we use is having a NFS, so we can generate files and share
them at the same time.

Israel.

System Administrator escribió:

>FTP is a bad idea (from security poinyt of view) in any cases.
>Try SSH with certificate and you'll be able send data without password (e.g. easy to send automatically etc).
>
>On Fri, 27 Jul 2007 22:50:34 +0530
>"Gaurav Chaudhary " <oracledba-ezmlmshield-x34754032.[Email address protected] wrote:
>
>
>
>>Hi Friends,
>>
>>I have a typical requirement to encrypt the data of .CSV or text file Using
>>Oracle and send it to client through FTP.
>>
>>Do we have any idea or anyone can provide me with any hint that how to do
>>it.
>>
>>May be you can suggest any other technique either using perl or shell script
>>or any other tool. But problem with the tool is that we need to schedule the
>>report generation so if you suggest any tool then that should be able to
>>incorporate in Scheduling task.
>>
>>Thanks in advance,
>>Gaurav
>>
>>
>>
>>Gaurav Chaudhary Sr Database Administrator | Cybage Software Pvt Ltd. (An
>>SEI CMMI Level 5 Company) | Marisoft, Kalyani Nagar | Pune, India - 411 006
>>Ph: 91 20 6604-1700 (Ext: 2810) | Fax: 91 20 6604-4701 | Mail To:
>>[Email address protected] | www.cybage.com
>>----- Original Message -----
>>From: "Stephen Price "
>><oracledba-ezmlmshield-x40110299.[Email address protected]
>>To: "LazyDBA Discussion" <[Email address protected]
>>Sent: Friday, July 27, 2007 10:13 PM
>>Subject: Error PLS-00201: identifier 'X$KGLOB' must be declared
>>
>>
>>
>>
>>>What is X$KGLOB and what do I have to do to get it into my DB instance?
>>>
>>>
>>>
>>>Query 'select owner, object_name, object_type from all_objects where
>>>object_name like '%KGLOB%';' returns no results...
>>>
>>>
>>>
>>>DBMS is 10.2.0.2 on Win32
>>>
>>>
>>>
>>>Cheers,
>>>
>>>Stephen
>>>
>>>
>>>
>>>Stephen Price
>>>Oracle Database Administrator
>>>Compusearch Software Systems, Inc.
>>>(o) 703.481.3699 x383
>>>(f) 703.481.3442
>>>21251 Ridgetop Cir, Suite 100
>>>Dulles, VA 20166
>>>[Email address protected] | www.compusearch.com
>>><http://www.compusearch.com/>
>>>
>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>>>To post a dba job: http://jobs.lazydba.com
>>>To Subscribe : http://www.LazyDBA.com
>>>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>>>
>>>
>>>
>>>
>>
>>---------------------------------------------------------------------
>>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>>To post a dba job: http://jobs.lazydba.com
>>To Subscribe : http://www.LazyDBA.com
>>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>>
>>
>>
>>
>>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>

Oracle LazyDBA home page