I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

Please check the box if you want to proceed.

I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.

Please check the box if you want to proceed.

By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.

for privacy and security reasons. We have made a batch program that is able to change data from a flat file. We use it on unloads of DB2 production databases and, afterwards, we are able to load the data into test databases. But Oracle only has the extract facility, which delivers binary files. Is there a similar way to do this or is there any other way to depersonalize data in a standard way? Oracle's export utility creates a dump of data in a proprietary binary format. However, you can still create flat files from the Oracle database, but not with the export utility. You can use SQL*Plus as follows:

set echo off
set heading off
set feadback off
set pagesize 0
spool flat_file.txt
select col_A||','||col_B||','||col_C||','||col_D
from my_table;
spool off

The other option is to use Oracle's DBMS_UTILITY.TABLE_TO_COMMA supplied procedure. It assists in making comma-delimited flat files.

Start the conversation

0 comments

Register

I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

Please check the box if you want to proceed.

I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.