Start a new topic

Modify a database colon (ORACLE)

The database import script may indicate (check the logfile) that values had to be truncated during import. This means that the column width in the event table is too small for the values it needs to store. This should only apply to string (varchar) type of values. To change :

1. Obtain the ProactivePack database credentials, the name of the ProactivePack database (by default “EVENTDB”) and the name of the events table (by default EVENT_REP_MAIN)

2. Run the following command  (assuming the DBUser is “PpackUser” and service name is MyDB)
sqlplus –u PpackUse@MyDB

3. Enter the ProactivePack user password
Within the prompt, type in a statement as follows

alter table event_rep_main
modify (<slotname> varchar2(<new width>) ;
 

<slotname> is the name of the new slot

<new width> is the numerical value of the column width (e.g. 256) 

 

4. Edit (using a text editor) the file $PRODUCT_HOME/config/custom/QuickQueries.conf

a. In the last section of the file ( [SQLImportParameters]), add a row for your new slot like follows :

length_<slotname>=<new width>

 

Example :


  sqlplus BMC_PAP@DB_PPACK.proactivepack.com 

 

SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 21 11:27:32 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

 

Enter password:

Last Successful login time: Wed Sep 21 2016 11:15:41 +02:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters and Automatic Storage Management options

 

SQL> alter table EVENT_REP_MAIN modify

  (

  mc_priority varchar2(14),

 mc_original_priority varchar2(14),

  mc_parameter_value varchar2(1024)

  );

 

Table altered.

  

Login or Signup to post a comment