Re: 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]] *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>
>
> 

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