Re: Rename

Hi,

Nice question.

I'm sure there are many (simpler?) ways but I though of this one first.

1. Create a second temporary database
2. Create the new username in that database
3. Create all the neccessary tablespaces in that database
4. Export the source user from the source database into a unix pipe
5. Import from the pipe into the temporary database (use the fromuser and touser imp flags)
6. Trash the source database
7. Copy the temporary database and call it the source database name
8. Trash the temporary database
9. Now you need to sort any grants to the new username

Anybody else?

J

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
Received on Fri May 24 2002 - 05:42:05 CDT