current position:Home>Oracle12c invalid create index option

Oracle12c invalid create index option

2022-02-02 20:14:01 CSDN Q & A

oracle12c Prompt when creating index invalid CREATE INDEX Options .

Client tools :datagrip

Create a table structure statement

-- Create table CREATE TABLE IT_EMPLAYEES ( EMPLOYEE_ID NUMBER(6) not null unique,    FIRST_NAME VARCHAR2(20),    LAST_NAME VARCHAR2(25) not null,    EMAIL VARCHAR2(25),    PHONE_NUMBER varchar2(20),    JOB_ID VARCHAR2(10),    SALARY NUMBER(8,2),    MANAGER_ID NUMBER(6));
create index it_lastname on IT_EMPLAYEES(LAST_NAME);

Running results

img

I ask you how to solve it ?




Refer to the answer 1:

The statement is no problem ,datagrip This client does not support .
navicat You can try it .

img




Refer to the answer 2:



Refer to the answer 3:

adopt sql sentence Inquire about

select * from session_privs;

The query results are as follows 34 rows Yes CREATE ANY INDEX Authority

img

Giving users permission is dba jurisdiction ,
Error message Seems to be datagrip I won't support it create index The grammar is the same ?

img




Refer to the answer 4:



Refer to the answer 5:

Indeed, the client does not support the current create index The problem of grammar , Another client successfully executed .

img


I don't know DATAGRIP Client's BUG




Refer to the answer 6:



Refer to the answer 7:

Your current login user , Is there no permission to create an index ?




Refer to the answer 8:

copyright notice
author[CSDN Q & A],Please bring the original link to reprint, thank you.
https://en.primo.wiki/2022/02/202202022013589336.html

Random recommended