Newsgroups: comp.databases.oracle.misc From: Brian Peasland Subject: Re: How to reset Sequence values ? X-Nntp-Posting-Host: edcntw241.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <3A7AB791.288113D1@edcmail.cr.usgs.gov> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: Raytheon Systems X-Accept-Language: en References: <94ouvh$jrr$1@marte.lastminutetour.com> <94pbtp$cbu$1@nnrp1.deja.com> <3A71881D.2F0A1BC1@edcmail.cr.usgs.gov> <95bc9t$8f1$1@nnrp1.deja.com> <3A796D99.63BF554C@edcmail.cr.usgs.gov> <95bv0c$nr4$1@nnrp1.deja.com> <981043436.11199.0.nnrp-08.9e984b29@news.demon.co.uk> Mime-Version: 1.0 Date: Fri, 2 Feb 2001 13:35:13 GMT X-Mailer: Mozilla 4.61 [en] (WinNT; U) Lines: 24 > 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! ========================================