Write compressed tables to database

Dear community and Database experts,
in ONE DATA we have the possibility to write data to an existing table on the database. In my case this would be an Oracle-DB.
We have a quite large table in ONE DATA: roughly 10 billion rows with 5 columns (double and string). We want to write this table to the Oracle database, such that other users can use this table for their analysis.


  • Is it possible to store a compressed table on the Oracle DB from within ONE DATA?
  • Is there a built-in functionality or would I need to create a compressed table first and then append into that one?
  • Does this table-compression only help to reduce the storage-amount on the database or will also the amount of data transferred from ONE DATA to Oracle via JDBC reduced?#

Thank you for your help!