This is a subset of the LERG called the NNACL-TB. It is pronounced “nackle”.
Login as UID ossadmin.
Navigate to the directory $NexOSS_HOME/sql/LERG and copy the NNACLTB.DAT file to this directory.
Login to sqlplus.
$ sqlplus username/password@database name
Execute the telcodata pre-load script.
SQL> @nnacltb_pre_load.sql
Login to sqlldr.
$ sqlldr username/password@database name
Load the control file.
control = nnacltb_load_instr.ctl
Login again to sqlplus.
$ sqlplus username/password@database name
Execute the post-load script.
SQL> @ nnacltb_post_load.sql