Re: Can one rename a database user (schema) with oracle9i ?

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Fri, 22 Aug 2003 11:58:49 +0300
Message-ID: <3f45db67$1_1@news.estpak.ee>

No, there's no supported way of doing it with a simple command. Drop & recreate instead. If you got data under the user, then export; drop; recreate; import.

Tanel.

"Luigi" <LuiginospamMarzella_at_libero.it> wrote in message news:ckj1b.257267$lK4.7950619_at_twister1.libero.it...
> Dear all,
> as stated on the subject I'd like to know if with Oracle 9i there's
> a built-in command to rename a user schema.
> Thanks a lot
> Luigi
>
>
Received on Fri Aug 22 2003 - 03:58:49 CDT

This message: [ Message body ]
Next message: Dusan Bolek: "Re: OT, but quite educational if you got the time to read it."
Previous message: Niall Litchfield: "Re: How to check if a query is using an index ?"
In reply to: Luigi: "Can one rename a database user (schema) with oracle9i ?"
Next in thread: Harald Maier: "Re: Can one rename a database user (schema) with oracle9i ?"
Reply: Harald Maier: "Re: Can one rename a database user (schema) with oracle9i ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US