CODEWITHSUNDEEP
sqloracle-database
Mohammed Housseyn Taleb
Mohammed Housseyn Taleb

Reputation: 1828

sql create temporary table invalid identifier exception

CREATE GLOBAL TEMPORARY TABLE m_product_forecast (
    m_product_forecast_id   NUMBER
        NOT NULL ENABLE,
    forecast_mode           CHAR(1 BYTE) DEFAULT 'D'
        NOT NULL ENABLE,
    forecast_qty            NUMBER DEFAULT 1
        NOT NULL ENABLE,
    CHECK ( forecast_mode IN (
        'D',
        'P'
    ) ) ENABLE,
    CONSTRAINT "M_PRODUCT_FORECAST_KEY" PRIMARY KEY ( "m_product_forecast_id",
                                                      "forecast_mode" )
) ON COMMIT PRESERVE ROWS

The exception is

ORA-00904: "m_product_forecast_id" : identificateur non valide

What is wrong ??

Upvotes: 0

Views: 190

Answers (1)

user330315
user330315

Reputation:

Remove the double quotes: "

As documented in the manual "m_product_forecast_id" is a different name than m_product_forecast_id

Upvotes: 2

Related Questions