Load TelcoData

1. Login to the OSS system as UID ossadmin.

2. Navigate to the directory $NexOSS_HOME/sql/LERG

3. Copy your nanpa file to this directory.

   • Note: If the file that you obtained is nanpa-sorta-thousands.csv, change its name to nanpa_sorta_thousands.csv

   [ossadmin@NEXOSS LERG]$ mv nanpa-sorta-thousands.csv nanpa_sorta_thousands.csv
   

4. Login to sqlplus and execute the telcodata pre-load script.

   [ossadmin@NEXOSS LERG]$ sqlplus /
   @SID
   SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 9 11:08:04 2007
   Copyright (c) 1982, 2005, Oracle. All rights reserved.
   Connected to:
   Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
   With the Partitioning, OLAP and Data Mining options
   SQL> @telcodata_pre_load
   drop table LERG_6
   *
   ERROR at line 1:
   ORA-00942: table or view does not exist
   Table created.
   Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
   With the Partitioning, OLAP and Data Mining options
   [ossadmin@NEXOSS LERG]$
   

5. Login to sqlldr and load the control file.

   [ossadmin@NEXOSS LERG]$ sqlldr /
   @SID
   
   control = telcodata_load_instr.ctl
   
   SQL*Loader: Release 10.2.0.1.0 - Production on Fri Nov 9 11:11:32 2007
   
   Copyright (c) 1982, 2005, Oracle. All rights reserved.
   
   Commit point reached - logical record count 64
   Commit point reached - logical record count 128
   Commit point reached - logical record count 192
   Commit point reached - logical record count 256
   Commit point reached - logical record count 320
   ~
   Commit point reached - logical record count 347169
   Commit point reached - logical record count 347233
   Commit point reached - logical record count 347297
   Commit point reached - logical record count 347361
   Commit point reached - logical record count 347412
   [ossadmin@NEXOSS LERG]$
   

6. Login again to sqlplus and execute the post-load script.

   [ossadmin@NEXOSS LERG]$ sqlplus /
   @SID
   SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 9 11:12:57 2007
   Copyright (c) 1982, 2005, Oracle. All rights reserved.
   Connected to:
   Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
   With the Partitioning, OLAP and Data Mining options
   SQL> @telcodata_post_load
   Index created.
   Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
   With the Partitioning, OLAP and Data Mining options