RE: Bug in TOAD 11

Is the script shown below what the 'create index' dialog generated?  I just ran this sql and it worked fine for me (I changed object names of course but left everything else along).

You mentioned what client you are using.  What Oracle version are you using?


From: [email protected] [mailto:[email protected]] On Behalf Of Louis BROUILLETTE
Sent: Wednesday, September 28, 2011 3:50 PM
To: [email protected]
Subject: [toad] Bug in TOAD 11



Hi everyone,

In TOAD 11, windows XP, instant client 11.2.0.2

Schema browser, I select a table. On RHS, in the indexes tab, I do
"create index", complete everything and hit "Show SQL". I then copy the
SQL and cancle the operation. I go to the SQL editor and paste the
"create index" command.

I get "ORA-02158": invalid create index option.

I execute the same "create index" in TOAD 10.6 and it works like a charm.

Yesterday, I got the same problem. Instead of going to 10.6, I just
retype the command and it worked.

Here is the create index:
CREATE INDEX DBAGEST.GSC_FORM_REQUETE_NUK1 ON DBAGEST.GSC_FORM_REQUETE
(NO_FORMULAIRE, NO_VERSION_FORM)
LOGGING
TABLESPACE AUTRES_IND
STORAGE (
INITIAL 512K
NEXT 512K
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
/

--
Louis Brouillette
Chargé de projet informatique et technologique (DBA)
Université du Québec à Trois-Rivières
Tel: (819) 376-5011 ext. 2435
Email: [email protected]<mailto:Louis.Brouillette%40uqtr.ca>