ORA-12899: value too large for column ??? (actual: 20, maximum: 15)

We are trying to create a table using CTAS, source is a view from a view.

Database Version : 11.2.0.2 BP17 running on Exadata X2-2

Problem Summary

---------------------------------------------------
error creating a table on exadata database using CTAS.

Problem Description
---------------------------------------------------
SQL> CREATE TABLE B_TEST02
AS
select incident_number,
closed_date_et
from rpt_incident_base 2 3 4 5 ;
select incident_number,
*
ERROR at line 3:
ORA-12899: value too large for column ??? (actual: 20, maximum: 15)

Error Codes
---------------------------------------------------
ORA-12899

Created a Sev 2 SR for my problem, after of so many updates from oracle support. a bug was raised.

BUG # 15835753 – ORA-12899 WHILE CTAS ( CREATE TABLE AS SELECT)

i will update once fix is provided.

Update from Oracle

    Hdr: 15835753 11.2.0.2 RDBMS 11.2.0.2 SQL EXECUTION PRODID-5 PORTID-226 ORA-12899
    Abstract: ORA-12899 ON CREATE TABLE AS SELECT
     
    *** 11/06/12 12:24 am ***
     
    PROBLEM:
    --------
    Customer is getting 
    ORA-12899: value too large for column ??? (actual: 20, maximum: 15)
    while CTAS - create table as select.
     
    Command 
    SQL> CREATE TABLE B_TEST02 AS
    select incident_number, closed_date_et
      from rpt_incident_base ;
     
    select incident_number,
           *
    ERROR at line 3:
    ORA-12899: value too large for column ??? (actual: 20, maximum: 15)
     
     
    nls_length_semantics    is      BYTE 
     
    SQL> desc rpt_incident_base;
    Name                                      Null?    Type
    ----------------------------------------- -------- 
    ----------------------------
    INCIDENT_NUMBER                                    VARCHAR2(15) 
    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< create table test_A as select incident_number from 
    aradmin.hpd_help_desk;
    Table created.
     
    WORKAROUND:
    -----------
    None
     
    RELATED BUGS:
    -------------
     
    REPRODUCIBILITY:
    ----------------
     
    TEST CASE:
    ----------
     
    STACK TRACE:
    ------------
     skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
            <- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction <- 
    dbgdRunActions <- dbgdProcessEventAct
             <- ions <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- 
    PGOSF13_ksfpec <- dbgePostErrorKGE
              <- 1122 <- dbkePostKGE_kgsf <- kgesev <- ksesec3 <- kxcsvtl
               <- qerlt_snv <- qerltRop <- qerpxFetch <- rwsfcd <- qerltFetch
                <- ctcdrv <- opiexe <- opiosq0 <- kpooprx <- kpoal8
                 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr
                  <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
                   <- libc_start_main <- start
     
    SUPPORTING INFORMATION:
    -----------------------
    Error Stack trace
    DDL of tables and views
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s