Load LERG Data into Oracle DB

  1. Login into the OSS system as UID ossadmin.

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

  3. Copy your LERG file to this directory.

  4. Login to sqlplus and execute the LERG 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> @lerg_6_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]$
  1. Login to sqlldr and load the control file.
   [ossadmin@NEXOSS LERG]$ sqlldr /
   @SID
   control = lerg_6_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]$
  1. 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> @lerg_6_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