Loading Serviceability Extended Attributes Data - serviceability_extended_attributes - Main

Serviceability Extended Attributes Getting Started Guide
Product
Address Fabric™ Data > Serviceability Extended Attributes
Version
Main
Language
English
Portfolio
Enrich
Product family
world_addresses
Product name
Serviceability Extended Attributes
Title
Serviceability Extended Attributes Getting Started Guide
Copyright
2023
First publish date
2022
  1. Download the product delivery file
  2. Extract the delivery file and find the data text file
  3. Open the SEA Create Table script in a text editor and confirm that the table name is set to serviceability_extended_attributes
  4. Run the Create Table script
  5. After the table structure has been created, copy the Oracle CTL template into the directory containing the product delivery file
  6. Open the CTL file in a text editor
  7. Add the path to the extracted data text file to the infile statement
  8. Replace Oracle destination table name with serviceability_extended_attributes.
  9. Save changes
  10. Load data by issuing the following command from a Windows command prompt:
    sqlldr userid=<username>/<password>@<database_connection>
control=<path>/<ctl_file_name> log=<path>/<log_file_name>
Note: The TRAILING NULLCOLS clause used in the CTL file instructs SQL Loader to treat any relatively positioned columns that are not present in the record as null columns.