Is there a way to easily switch between cdb / pdb in Toad ?
It would be great to have a button, especially in schema and session browsers, to instantly switch.
Now, I have to open a editor, 'alter session set container=... "
Then go back to schema browser and refresh.
Or have 2 sessions - 1 to cdb and 1 to pdb, this eats up a lot of resources when I have many db.
It seems to me that by now there would be something, but I have not seen it.
Thanks!
Now, I have to open a editor, 'alter session set container=... "
Then go back to schema browser and refresh.
careful with that. If you're going to do that then you'll want to make sure these options are set right, otherwise, not everything is going to happen in the right container.
In Options->Oracle->Transactions
Execute queries in threads should be unchecked.
Execute scripts in Toad session should be checked
Session for Explain plan should be "Main Toad session"
Also, there is a tool bar button that switches the context of your connection, and it exists for both Schema Browser and the Editor. Look the for icon that resembles an electric cord. See snaps below.
Hi,
Thanks for the update. That it the button I already use now to switch which connection I use.
What I'm thinking it a similar button to switch from the cdb to the pbd of the same connection.
Maybe the button would do "alter session set container=cdb$root' or something like that.
Actually I think the connection bar button would be a better place to do it, so it could trickle out to all background sessions (if any). I don't think there should be any attempt to do this just for one window of a connection, because usually they are all using the same session. But we could put some kind if indicator on the connection to say if it's switched to another container.
It's a good idea though, and I don't think you are the first to ask about it. I'll look at it for 13.3