Provision NNACL Data to LERG

This is a subset of the LERG called the NNACL-TB. It is pronounced “nackle”.

  1. Login as UID ossadmin.

  2. Navigate to the directory $NexOSS_HOME/sql/LERG and copy the NNACLTB.DAT file to this directory.

  3. Login to sqlplus.

   $ sqlplus username/password@database name
  1. Execute the telcodata pre-load script.
   SQL> @nnacltb_pre_load.sql
  1. Login to sqlldr.
   $ sqlldr username/password@database name
  1. Load the control file.
   control = nnacltb_load_instr.ctl
  1. Login again to sqlplus.
   $ sqlplus username/password@database name
  1. Execute the post-load script.
   SQL> @ nnacltb_post_load.sql