Login to the OSS system as UID ossadmin.
Navigate to the directory $NexOSS_HOME/sql/LERG
Copy your nanpa file to this directory.
[ossadmin@NEXOSS LERG]$ mv nanpa-sorta-thousands.csv nanpa_sorta_thousands.csv
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]$
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]$
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