Synonyms ?
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Brian Peasland wrote in message <3A796D99.63BF554C_at_edcmail.cr.usgs.gov>...
>Michael,
>
>Interesting... How do you propose renaming the sequence? There is no
>ALTER SEQUENCE RENAME command.
>
>But if you could, then I suppose you could guarantee automicity. You
>could also guarantee it by starting the database in restricted mode and
>altering the sequence as previously suggested. But this is still a long
>way to go when it is much easier to just drop and recreate the sequence.
>
Received on Thu Feb 01 2001 - 09:11:44 CST
