Versions Compared

Old Version 8

changes.mady.by.user Vladimir Ozerov Ozerov

Saved on

compared with

New Version 9

changes.mady.by.user Vladimir Ozerov Ozerov

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Oracle offers "direct path load" [1] as the fastest method to populate data. Direct path load can be from both command line utility SQL*Loader to load existing files (resembling Ignite's COPY command), and with conventional with conventional SQL, such as {{INSERT}} and {{INSERT and CREATE TABLE AS SELECT}}  (CTAS).

[1] https://docs.oracle.com/cd/E11882_01/server.112/e22490/ldr_modes.htm#SUTIL009
[2] https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-tables.html#GUID-134D6EB6-219E-4820-AB54-8C60067A8F0F

...