[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1697?page=c... ] Vlad Skarzhevskyy commented on HHH-1697: ---------------------------------------- Actual after consulting with our DBA I suggest this SQL to get the list of sequences! SELECT sequence_name FROM user_sequences UNION SELECT synonym_name FROM user_synonyms us WHERE EXISTS ( SELECT 1 FROM all_sequences asq WHERE asq.sequence_name = us.table_name AND asq.sequence_owner = us.table_owner ) Statement check the object owner is the same as a table owner in the synonyms. (to eliminate the case when the sequence is decalred under the owner different from these in the synonym declaration). public String getQuerySequencesString() { return "SELECT sequence_name " + " FROM user_sequences " + "UNION " + "SELECT synonym_name " + " FROM user_synonyms us " + "WHERE EXISTS ( " + " SELECT 1 " + " FROM all_sequences asq " + " WHERE asq.sequence_name = us.table_name" + " AND asq.sequence_owner = us.table_owner)"; } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira