Feb 21, 2007 #1 oracleSQLdba IS-IT--Management Nov 2, 2006 53 US How can I tell the sequences owned by my Schema? I'm looking for the SQL statement... Thanks
Feb 21, 2007 #2 KenCunningham Technical User Mar 20, 2001 8,475 GB select owner, object_name from dba_objects where object_type = 'SEQUENCE'; I want to be good, is that not enough? Upvote 0 Downvote
select owner, object_name from dba_objects where object_type = 'SEQUENCE'; I want to be good, is that not enough?