FLUSH TABLES - all databases?
Greetings,
When executing a "FLUSH TABLES" query, does the query flush open tables on the entire server? Even if a database is selected?
The reason I am asking is because the documentation indicates that if no tables are specified in the FLUSH TABLES WITH READ LOCK query, then all of the tables on all of the databases are flushed and locked.
I'm curious is the behavior is the same for the FLUSH TABLES without the read lock... if FLUSH TABLES is executed with no tables specified, even if a database is specified previously with USE, does it flush all the open tables on a server?
Thanks!
Caio
Subject
Views
Written By
Posted
FLUSH TABLES - all databases?
8396
July 08, 2008 11:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.