RE: Bug in TOAD 11

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