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
    
  4. Execute the telcodata pre-load script.

    SQL> @nnacltb_pre_load.sql
    
  5. Login to sqlldr.

    $ sqlldr username/password@database name
    
  6. Load the control file.

    control = nnacltb_load_instr.ctl
    
  7. Login again to sqlplus.

    $ sqlplus username/password@database name
    
  8. Execute the post-load script.

    SQL> @ nnacltb_post_load.sql