ORA-01792: maximum number of columns in a table or view is 1000 Oracle 12c (12.1.0.2.0) — oracle-mosc

Database Administration (MOSC)

MOSC Banner

ORA-01792: maximum number of columns in a table or view is 1000 Oracle 12c (12.1.0.2.0)

edited Jan 4, 2016 7:58AM in Database Administration (MOSC) 2 commentsAnswered ✓

Hello,

I have query with multiple joins. When i run this query i qet error ORA-01792: maximum number of columns in a table or view is 1000

When i remove last join then query work good. Is it bug in oracle?



WIP_OPERATION is empty ....

(SELECT

    1

  FROM

    WIP_OPERATION WOP where

     rownum = 1) as x

SELECT

(SELECT

    1

  FROM

    WIP_OPERATION WOP where

     rownum = 1) as x

FROM

      WIP_ORDER SRC

      LEFT OUTER JOIN PRODUCT PP ON SRC.PRODUCTID= PP.ID

      LEFT OUTER JOIN PROCESS PR ON SRC.PROCESSID=PR.ID

      LEFT OUTER JOIN RECIPE RR ON SRC.RECIPEID = RR.ID

      LEFT OUTER JOIN RESOURCE_ R ON SRC.RESOURCENAME = R.RESOURCENAME AND SRC.RESOURCETYPE = R.RESOURCETYPE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center