Upload ZIP Data Files to Object Store for StageDataLoad Batch

Use these steps when uploading data files for the StageDataLoadBatch.

  1. Navigate to File Operation, then Data Platform, Administration and open File Operation.
  2. Click Upload File .
  3. Enter a File name and Extension, using the sample template file for reference.
    AMLCS_SYS_STAGE_ACCOUNT_ADDRESS_MAP_20141231_MAN.zip
  4. Select the File Type as Zip file.
  5. In the File Size field, provide the size of the file being uploaded ( in bytes).
  6. Click Generate . A PAR URL will generate.
  7. Copy the PAR URL generated above.
  8. Use curl to upload the file to the object store curl -X PUT --data-binary '@<csv-file-name>' <par_url>.
    For example:
     curl  -X PUT --data-binary '@AMLCS_SYS_STAGE_ACCOUNT_ADDRESS_MAP_20141231_MAN.zip'
                      https://objectstorage.oraclecloud.com/p/IWWPtdM1MNr_VG-I2p5YJldIxnNgAwbMHdrTfnqr3rM/n/oraclegbudevcorp/fsgbu_aml/default/2023-09-27/pim/1e291d3c58e1
  9. Check the status in the File Operation page.
  10. Repeat these steps for all Zip Files and all tables.