Re: Rename

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 24 May 2002 00:21:57 -0700
Message-ID: <a20d28ee.0205232321.c807025@posting.google.com>

Yogesh Sharma <res0nlrn_at_verizon.net> wrote in message news:<pan.2002.05.23.19.27.10.172676.22822_at_verizon.net>...
> Hello
>
> We have one 100 GB Oradle 8.1.7 database, Which has one user.
>
> How can I rename that username ? Any fast Solutions.
>
> Thanks
>
> YS

supported: export the user, drop the user, create the new user, import the export using fromuser= touser to the new user unsupported: find out which tables under SYS have a user# or owner# column and update them directly.
Note: If you screw up, Oracle Technical Support won't help you out.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri May 24 2002 - 02:21:57 CDT