NELNET decrease file

Problem Description :

Nelnet decrease file

Resolution :

1. Login to pebbles.gordonstate.edu as banmgr

2. $ cd /upgrades/banner/NELNET/banner/data*

3. $ pwd

/upgrades/banner/NELNET/banner/database_component

4. $ ll option*

-rw-r--r-- 1 banmgr ban 1237 Sep 10 2013 option4_uploadfile.sql

5. $ sqlplus NELNET/apple

enter - @option4_uploadfile.sql

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 1 13:46:44 2014

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Please enter the TERM CODE for the term you would like to create the NBS upload file for: 201408

old 2: tzwchng.process_changes('&&term_for_changes');

new 2: tzwchng.process_changes('201408');

PL/SQL procedure successfully completed.

0M232929120497 +0001945.38 07012014

0M232929140450 +0000850.02 07012014

0M232929190523 +0000739.68 07012014

0M232929014351 +0000739.68 07012014

0M232929194031 +0006270.00 07012014

0M232929184291 +0000757.71 07012014

0M232929085492 +0002075.00 07012014

0M232929183572 +0002195.00 07012014

0M232929139683 +0001148.02 07012014

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

6. $ ll NBS*

-rw-r--r-- 1 banmgr ban 459 Jul 1 13:47 NBSupload.txt

7. move the NBSupload.txt file down to your c drive. (file is in /upgrades/banner/NELNET/banner/database_component)

8. email the file to The requester

Revision Date : 6/16/2016