Load a Fixed-Width File into a New Table
This
provides an example using DBMS_CLOUD.CREATE_EXTERNAL_TABLE
to load data from a fixed-width
source file to an external table.
For this example, the fixed-width source file has the following data:
0INDEX01 INDEX 2001272020012720200127VALID 1INDEX02 INDEX 2001272020012720200127VALID 2INDEX03 INDEX 2001272020012720200127VALID 3INDEX04 INDEX 2001272020012720200127VALID 4TABLE01 TABLE 2001272020012720200918VALID 5TABLE02 TABLE 2001272020012720200918VALID 6CLUSTER01 CLUSTER 2001272020012720200127VALID 7INDEX05 INDEX 2001272020012720200127VALID 8INDEX06 INDEX 2001272020012720200127VALID 9INDEX07 INDEX 2001272020012720200127VALID 10INDEX08 INDEX 2001272020012720200127VALID 11TABLE03 TABLE 2001272020012720200127VALID 12INDEX09 INDEX 2001272020012720200127VALID 13INDEX10 INDEX 2001272020012720200127VALID 14TABLE04 TABLE 2001272020012720200127VALID 15INDEX11 INDEX 2001272020012720200127VALID
Parent topic: Examples for Loading Data into Autonomous Database