There is no "ALTER SEQUENCE <name> RENAME..." syntax, and "RENAME <old_name> to <new_name>" does not allow a schema qualification. So my Oracle brain teaser for the day is, "How can we rename a sequence that another user owns without connecting as the owner?"
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel."
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.