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