Re: Bug in TOAD 11

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?
>
> *From:*[email protected] [mailto:[email protected]] *On Behalf 
> Of *Louis BROUILLETTE
> *Sent:* Thursday, September 29, 2011 8:10 AM
> *To:* [email protected]
> *Subject:* Re: [toad] Bug in TOAD 11
>
> 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?
>
>     *From:*[email protected] <mailto:[email protected]>
>     [mailto:[email protected]] *On Behalf Of *Louis BROUILLETTE
>     *Sent:* Wednesday, September 28, 2011 3:50 PM
>     *To:* [email protected] <mailto:[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>
>
>
>
> -- 
> 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:[email protected]>
>
> 

-- 
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]