Prepare External Table for Loading Point Clouds

After down from data set from OpenTopography. I am interest in points.txt only when gz file was decompressed. Oracle Spatial User Developer Guide did not document well on how to load point cloud data set into Oracle database. Instead, I found the steps from "Pro Oracle Spatial for Oracle Database 11g" Appendix E.

I am going to create an external table link to points.txt as POINTS for loading points into Oracle SDO_PC data type. Before creating an external table, I need to create a directory, PC_DIR, and put point.tx on that directory.

Login as system to create PC_DIR.
create or replace directory "PC_DIR" as '/u01/opt/PC_dataset';

And grant READ & WRITE rights to user at least
grant read, write on directory PC_DIR to  fsms;

Now I can create an external table.

  CREATE TABLE "FSMS"."POINTS"
   ( "X" NUMBER,
"Y" NUMBER,
"Z" NUMBER,
"CLASSIFICATION" NUMBER,
"GPSTIME" NUMBER,
"SCAN_ANGLE" NUMBER,
"INTENSITY" NUMBER,
"NUMBER_OF_RETURNS" NUMBER,
"RETURN_NUMBER" NUMBER,
"POINT_SOURCE_ID" NUMBER,
"EDGE_OF_FLIGHT_LINE_FLAG" NUMBER,
"DIRECTION_OF_SCAN_FLAG" NUMBER,
"USER_DATA" NUMBER,
"RED_CHANNEL" NUMBER,
"GREEN_CHANNEL" NUMBER,
"BLUE_CHANNEL" NUMBER
   )
   ORGANIZATION EXTERNAL
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "PC_DIR"
    
      LOCATION
       ( "PC_DIR":'points.txt'
       )
    )
   REJECT LIMIT UNLIMITED;

Following the steps from Appendix E