Sequence is one of the useful features of Oracle. This is used in column requiring auto-numbering. This automatically increment the value on a given increment range. What if these sequences are almost near to it's max value? What will happened then? Check the details in http://www.itexpertscentral.com/ExpertsJournal/tabid/60/EntryID/7/Default.aspx