Toad World® Forums

Tablespaces not refreshing after altering in Schema Browser

#1

Hi,

I don’t know if this behavior is as intended, but I think it could be improved: if you change a tablespace from READ ONLY to writable -or the opposite-, the lock icon remains in place until you manually refresh the window.

Shouldn’t that be done automatically? (at least, for the affected tablespace)

Regards,

#2

There’s an option for that. Options -> Schema Browser -> Left Hand Side -> Refresh Schema Browser after an object is created/altered

#3

Indeed it is, thanks!!!

Regards,

#4

Hi!

I enabled the option but didn’t try it until now… it seems that altering the read_only attribute for tablespaces doesn’t trigger the autorefresh of left side :frowning:

Regards,

#5

What’s your process to alter the tablespace? I thought you were double-clicking in and going into the alter tablespace dialog, but maybe you are changing it to read only some other way.

#6

Yes, that’s it. Double click or right-click and ‘Alter tablespace’, go to ‘Basic Info’ tab, and the check (or uncheck) the read-only button.

The lock icon doesn’t appear or disappear - there’s no refresh of the left side after performing the operation.

Regards,

#7

It’s working as expected for me. There are two checkboxes in options - one to refresh after creates, the other to refresh after alters. You have the “alter” one checked, right?

#8

I have both of them checked, but it’s not working.

I’m using the Dropdown view, are you using it too?

#9

Yes, dropdown. WIll you click Help -> Support Bundle and send me that information? You can email it to me directly if you’d like: john.dorlon@quest.com

#10

Thanks, I emailed the info.

#11

Incase anyone is following this thread: The problem only happened when the Schema Browser was set to a schema other than the login schema. It’s fixed for when betas start again.

#12

Hi,

I've noticed that this issue is happening in TOAD 13.1 Final.
Could you please check if it's present in latest 13.2 beta as well and fix it?

Regards,

#13

For me, it works in 13.1. Make sure this option is checked:

Options -> Schema Browser -> Left Hand SIde -> Refresh Schema Browser after an object is altered.

#14

Yup, that worked! I guess if those options should be enabled by default...

Cheers,

1 Like