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?
Hi
Try removing the semi-colon at the end.
David
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.
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 ;-)
Thank you very much! After removing the semi-colon it works well!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.