Renaming user in oracle 9i

[Adil Akbar]

hi guys!
Can i change the name of users which i have created?

[debasisdas]

sorry dear,

Oracle does not support this till now.
Not even in 10.2 version

[vijaydiwakar]

hi guys!
Can i change the name of users which i have created?

I think it may be possible try to use Oracle Enterprise Manager

[srikanthutpala]

I think it may be possible try to use Oracle Enterprise Manager

hi
u can not rename the user directly. but can rename user using bllow steps

1) take the user level export of <userA>
2) Create the user <user B>
3) import the user A export dump in to user B
4) drop the user <user A>

[debasisdas]

Dear srikanthutpala

do u understand the word RENAME.

[sanora600]

It is no way you can change the User name (schema name). you can rename fields, table and other objects but not schema directly.

The same result can be achieve by using export and imortp.
1. take schema level export
2. create the required user.
3. import the exported dump
4. delete the old users.

[gouthamirao]

I have created a user and inserted some tables with data using oracle9i. Can I know to which database these tables and user belong to? Do we have any command for knowing that?

[debasisdas]

I have created a user and inserted some tables with data using oracle9i. Can I know to which database these tables and user belong to? Do we have any command for knowing that?

that really sounds funny, how can you login without knowing the name of the database .Where you have created the user from which login ?

[gouthamirao]

I have created a user with a password by logging in as sysdba. I dint specify the database name over there. Then I logged in by that username and password and created tables.

[debasisdas]

what is the name that u specified at the time of creation of database.
by default that will be ORCL

if that is a local database in windows machine check the service name or in the TNSNAMES.ORA file.

else try the following

select instance_name,version from v$instance