File Creation and Upload

The extract data may be uploaded in both compressed and decompressed form.

Supported compressed formats include zip and gzip. The files with extension .gz and .zip will be automatically decompressed by the system.

Note: For the further details on supported compressed formats please refer to the Oracle Utilities Application Framework documentation.

File Creation

Use Conversion Task query to retrieve conversion task(s) for table(s) or maintenance object(s) that you are planning to convert. Review input data specifications. Create the data extract text file, using field delimiters, enclosing characters and data formatting according to the specifications.

If the files were created under Windows operating system, it is recommended to remove the carriage return character prior to compression (not applicable for secondary files with CLOB data).

File Compression with gzip

Use gzip utility to compress the file.

For Windows operating system, download and install gzip utility for Windows. Run the following:

# Navigate to the gzip folder

cd C:\gzip-1.3.12-1-bin\bin

# Run gzip.

# New file will be created in the same directory as the original the input file

gzip -k <full path to the input data file>

# Sample command for the file TABLE_NAME.txt located under

# C/myDataDirectory/:

gzip –k C/myDataDirectory/TABLE_NAME.txt
For Unix/Linux operating systems, run the following command:

gzip < <inputFile name> > <outputFile name with .gz suffix>

# Sample command for the file TABLE_NAME.txt

gzip < TABLE_NAME.txt > TABLE_NAME.txt.gz