Feb 21, 2007 #1 oracleSQLdba IS-IT--Management Joined Nov 2, 2006 Messages 53 Location 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 Joined Mar 20, 2001 Messages 8,475 Location 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?
Feb 21, 2007 #3 Dagon MIS Joined Jan 30, 2002 Messages 2,301 Location GB select * from user_sequences; Upvote 0 Downvote