• KWymore (6/26/2014)


    SQLRNNR (6/26/2014)


    Jeff Moden (6/26/2014)


    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.

    My eyes did the same thing. Then i chuckled. I'm thinking it is some Oracle developer's sense of humor coming to light.

    Considering my overall lack of Oracle expertise, Oracle probably did think I was an IDIOT!

    Glad others found it amusing too. 😀

    There is a bit of irony with that error too.

    Based on the verbiage, I presume it means you cannot partition a temp table in Oracle.

    According to Microsoft documentation you can't partition a temp table either.

    But in SQL Server you can definitely partition a temp table[/url].

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events