I have used this query to fetch the list of sequences belonging to an Oracle database user: SELECT * FROM all_sequences x,all_tables B WHERE x.sequence_owner=B.owner AND B.TABLE_NAME='my_table'; ...