Home Forums SQLServerCentral.com Editorials Byte Me: Insubordinate Clause RE: Byte Me: Insubordinate Clause

  • June 26, 2014 at 12:48 am

    #1724918

    KWymore (6/25/2014)

    Reminds me of the Oracle error I got the other day -

    SQL Error: ORA-14451: unsupported feature with temporary table

    14451. 00000 - "unsupported feature with temporary table"

    *Cause: An attempt was made to create an IOT, specify physical attributes,

    specify partition or parallel clause.

    *Action: do not do that.

    Thanks for the helpful resolution hint there Oracle...

    BWAAA-HAAA!!!! Sometimes my old eyes playing tricks on me provides the benefit of spontaneous and absolutely hilarious entertainment. Here's what I thought that error said when I first looked at it. Major SPOM momemnt! :-D:-P

    SQL Error: ORA-14451: unsupported feature with temporary table

    14451. 00000 - "unsupported feature with temporary table"

    *Cause: An attempt was made to create an IDIOT, specify physical attributes,

    specify partition or parallel clause.

    *Action: do not do that.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)