Toad World® Forums

Unwanted query in generated Alter code

Can’t figure this one out on my own.

Toad 12.8.0.49 Professional 64-bit w/DB Admin Module

Win 7 64-bit

I start the in Schema Browser, click Alter (an index), I make a change to the index. In this example I renamed a partition. When the SQL code is generated, along with the RENAME query it includes an Alter Index NO INMEMMORY query. How do I get it to leave out that query?

EX:

ALTER INDEX ACTUARY.MR_RUN_TIME
MODIFY PARTITION MRT_FUTURE_YEARS NO INMEMORY;

ALTER INDEX ACTUARY.MR_RUN_TIME
RENAME PARTITION MRT_FUTURE_YEARS
TO MRT_FUTURE_YEARS3;

Thank you sincerely for any assistance.

Best Regards,

Brian Keegan

Sr Oracle DBA

Farmers Insurance Group

Hi,

Could you post your Oracle client and server version?

Brg

Damir

Oops, sorry.

Client and database version are 12c. 12.1.0.2 to be specific.

– Brian

Hi,
Could you post picture of all 4 tabs from Alter dialog…just to get the feeling what are you doing.
Brg
Damir
P.S.
Are you dealing with any kind of IN MEMORY option for parent table?

Hi,

Here are some screen shots that document the process. Thanks for checking it out.

Regards,

Brian
Unwanted INMEMORY query in script.docx (356 KB)

I think it’s just a bug in 12.8. I’ll check on this soon.

Thanks John. I’ll document the one where the partition names get mixed up in another thread, unless that’s already known.

Thanks,

Brian

I don’t see this happening in the current version (although I do see something similar with the INDEXING parameter, which I just fixed for next beta).

By the way, starting in Toad 12.9, you can rename partitions directly from the SB RHS Partitions tab, so you don’t have to open the “alter index” window at all.

Please let me know the details of partition names getting mixed up - that one doesn’t sound familiar to me.