Re: How to reset Sequence values ?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 2 Feb 2001 13:35:13 GMT
Message-ID: <3A7AB791.288113D1@edcmail.cr.usgs.gov>

> Eeeh, when I were a lad, you could only rename a table !

Yes, that one got past me too!!! I even looked in the Oracle 8i The Complete Reference. The RENAME command (according to that book) only applies to tables. But when I tried to rename a sequence on Oracle 8.1.7, I got the message "Table renamed". And the sequence had in fact been renamed.

Cheers!
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Feb 02 2001 - 07:35:13 CST