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]$
    
  5. 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]$
    
  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> @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