Skip to main content
Solved

How can i create an non-spatial index in de Oracle-Spatial writer?

  • March 14, 2016
  • 4 replies
  • 27 views
jpdenboer
Contributor
Forum|alt.badge.img+2

I want is create (even) an non-spatial index in the Oracle-spatial writer. So i tried the "SQL Statement to execute After Translation" with the next SQL:

CREATE INDEX GBKN_ALLES_TST_INDEX ON GBKN_ALLES_TST

(DWGLAYER, KLS_KLASSE)

LOGGING

STORAGE (

BUFFER_POOL DEFAULT

FLASH_CACHE DEFAULT

CELL_FLASH_CACHE DEFAULT

)

NOPARALLEL;

But it failed...

error was `ORA-00911: invalid character'

What is wrong?

Best answer by david_r

Hi

Try removing the semi-colon at the end.

David

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    4 replies

    david_r
    Celebrity
    • david_rCelebrity
    • Best Answer
    • March 14, 2016

    Hi

    Try removing the semi-colon at the end.

    David

    K
    Forum|alt.badge.img+5
    • kim
    • March 14, 2016

    Hi

    Try removing the semi-colon at the end.

    David

    You are way too fast:) Checked it on my database here, the semi-colon is indeed the problem.

    david_r
    Celebrity
    • david_rCelebrity
    • March 14, 2016

    You are way too fast:) Checked it on my database here, the semi-colon is indeed the problem.

    It's always faster to reply when you've made the same mistake before ;-)

    jpdenboer
    Contributor
    Forum|alt.badge.img+2
    • jpdenboerContributor
    • Author
    • Contributor
    • September 23, 2016

    Thank you very much! After removing the semi-colon it works well!

    Community Stats

    32,154
    Posts
    122,047
    Replies
    39,812
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.