# Bug in TOAD 11 **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [September 28, 2011, 3:50pm UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727 "2011-09-28T15:50:09Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [September 28, 2011, 3:50pm UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/1 "2011-09-28T15:50:09Z")
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: Louis.Brouillette@uqtr.ca ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 28, 2011, 4:51pm UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/2 "2011-09-28T16:51:06Z")
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? ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [September 29, 2011, 8:10am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/3 "2011-09-29T08:10:27Z")
Oracle version is 10.2.0.5 It is what the ‘create index’ dialog generated. I also tried something else. From TOAD (schema browser), I generated the script of an existing table, copied the ‘create index’ part (one of the indexes), drop the index and I got the same error when trying to run the create index. As I said, the same script works fine with TOAD 10.6 (on the same database, same client). Le 2011-09-28 17:51, John Dorlon a écrit : 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? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 29, 2011, 8:26am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/4 "2011-09-29T08:26:54Z")
Hm. I just tried this on 10.2.0.1 (it’s the closest I have to 10.2.0.5) and the statement below works OK there too. If you paste the statement in the editor and run with F9, it should highlight the part of the statement that causes the error. What part is getting highlighted? ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [September 29, 2011, 8:45am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/5 "2011-09-29T08:45:37Z")
Sorry, it now works. Yesterday and the day before, I did it repeatedly and it never worked but now, everything seems fine. I’ll tell you if it happens again. Thanks. Le 2011-09-29 09:26, John Dorlon a écrit : Hm. I just tried this on 10.2.0.1 (it’s the closest I have to 10.2.0.5) and the statement below works OK there too. If you paste the statement in the editor and run with F9, it should highlight the part of the statement that causes the error. What part is getting highlighted? ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [September 30, 2011, 1:24am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/6 "2011-09-30T01:24:03Z")
Hi If I copy/paste CREATE TABLE TABLE\_XMLBINARY OF XMLType XMLTYPE store AS BINARY XML; to the TOAD v11 editor and run with F9, the keyword BINARY is highlighted Regards! On 29.9.2011 15:26, John Dorlon wrote: Hm. I just tried this on 10.2.0.1 (it’s the closest I have to 10.2.0.5) and the statement below works OK there too. If you paste the statement in the editor and run with F9, it should highlight the part of the statement that causes the error. What part is getting highlighted? – Aci Polajnar IT svetovalec – IT consultant [acip.vcf](https://global.discourse-cdn.com/quest/original/2X/7/7d6e70093e1105a08609b00ed961cb29691a27af.vcf) (328 Bytes) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 30, 2011, 8:14am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/7 "2011-09-30T08:14:49Z")
Binary XML Storage requires Oracle 11. So if you are still using that 10.2.0.5 database, that is why. ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [October 3, 2011, 2:23am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/8 "2011-10-03T02:23:59Z")
SEE ATTACHMENT ![image002.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/7e42a01395e08f35bf636eda47a232dd1c0a6bb3.jpeg) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [October 3, 2011, 2:23am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/9 "2011-10-03T02:23:59Z")
SEE ATTACHMENT ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/3e6e11da5d2965936044d8a537f5ca057ef32e9e.jpeg) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [October 3, 2011, 2:23am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/10 "2011-10-03T02:23:59Z")
SEE ATTACHMENT ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/eb1cfa5c5c3c8794a0116ded47526f65179ebf62.jpeg) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [October 3, 2011, 2:23am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/11 "2011-10-03T02:23:59Z")
SEE ATTACHMENT ![image005.gif](https://global.discourse-cdn.com/quest/original/2X/2/21a236c416ff28274d8bfca18fce07b8047e17a8.gif) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [October 3, 2011, 2:23am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/12 "2011-10-03T02:23:59Z")
SEE ATTACHMENT [acip.vcf](https://global.discourse-cdn.com/quest/original/2X/7/7d6e70093e1105a08609b00ed961cb29691a27af.vcf) (328 Bytes) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [October 3, 2011, 2:23am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/13 "2011-10-03T02:23:59Z")
SEE ATTACHMENT ![image003.gif](https://global.discourse-cdn.com/quest/original/2X/2/23dc0bcabc260e2cfa371cfd7e9c6ed59a4d65e8.gif) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [October 3, 2011, 8:19am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/14 "2011-10-03T08:19:41Z")
Hi Aci, Sorry, I thought earlier you said you were using Oracle 10. I am not sure what is wrong. I tried Toad 11.0 with Oracle 11.2.0.1 and that create table statement worked just fine for me. I also tried with Oracle 11.1.0.6 and no problems there either. -John ![image005.gif](https://global.discourse-cdn.com/quest/original/2X/2/21a236c416ff28274d8bfca18fce07b8047e17a8.gif) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [October 3, 2011, 8:19am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/15 "2011-10-03T08:19:41Z")
Hi Aci, Sorry, I thought earlier you said you were using Oracle 10. I am not sure what is wrong. I tried Toad 11.0 with Oracle 11.2.0.1 and that create table statement worked just fine for me. I also tried with Oracle 11.1.0.6 and no problems there either. -John ![image003.gif](https://global.discourse-cdn.com/quest/original/2X/2/23dc0bcabc260e2cfa371cfd7e9c6ed59a4d65e8.gif) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [October 3, 2011, 8:19am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/16 "2011-10-03T08:19:41Z")
Hi Aci, Sorry, I thought earlier you said you were using Oracle 10. I am not sure what is wrong. I tried Toad 11.0 with Oracle 11.2.0.1 and that create table statement worked just fine for me. I also tried with Oracle 11.1.0.6 and no problems there either. -John ![image002.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/7e42a01395e08f35bf636eda47a232dd1c0a6bb3.jpeg) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [October 3, 2011, 8:19am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/17 "2011-10-03T08:19:41Z")
Hi Aci, Sorry, I thought earlier you said you were using Oracle 10. I am not sure what is wrong. I tried Toad 11.0 with Oracle 11.2.0.1 and that create table statement worked just fine for me. I also tried with Oracle 11.1.0.6 and no problems there either. -John ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/3e6e11da5d2965936044d8a537f5ca057ef32e9e.jpeg) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [October 3, 2011, 8:19am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/18 "2011-10-03T08:19:41Z")
Hi Aci, Sorry, I thought earlier you said you were using Oracle 10. I am not sure what is wrong. I tried Toad 11.0 with Oracle 11.2.0.1 and that create table statement worked just fine for me. I also tried with Oracle 11.1.0.6 and no problems there either. -John ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/eb1cfa5c5c3c8794a0116ded47526f65179ebf62.jpeg) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [October 3, 2011, 8:56am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/19 "2011-10-03T08:56:15Z")
You’re not using a 10 client with 11 database are you? Maybe Toad 11 is using the wrong Oracle home? ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/eb1cfa5c5c3c8794a0116ded47526f65179ebf62.jpeg) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [October 3, 2011, 8:56am UTC](https://forums.toadworld.com/t/bug-in-toad-11/10727/20 "2011-10-03T08:56:15Z")
You’re not using a 10 client with 11 database are you? Maybe Toad 11 is using the wrong Oracle home? ![image003.gif](https://global.discourse-cdn.com/quest/original/2X/2/23dc0bcabc260e2cfa371cfd7e9c6ed59a4d65e8.gif) [Next page](https://forums.toadworld.com/t/bug-in-toad-11/10727.md?page=2)