Toad World® Forums

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: Louis.Brouillette@uqtr.ca

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?

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?

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?

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?

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 (328 Bytes)

Binary XML Storage requires Oracle 11. So if you are still using that 10.2.0.5
database, that is why.

SEE ATTACHMENT
image002.jpeg

SEE ATTACHMENT
image001.jpeg

SEE ATTACHMENT
image004.jpeg

SEE ATTACHMENT
image005.gif

SEE ATTACHMENT
acip.vcf (328 Bytes)

SEE ATTACHMENT
image003.gif

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

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

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

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

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

You’re not using a 10 client with 11 database are you? Maybe Toad 11 is
using the wrong Oracle home?
image004.jpeg

You’re not using a 10 client with 11 database are you? Maybe Toad 11 is
using the wrong Oracle home?
image003.gif