OraFAQ Forum: General » Two users similar... which destroy?

Home » Other » General » Two users similar... which destroy?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tue, 10 September 2002 06:24

Matthew frm Italy
Messages: 1
Registered: September 2002

Junior Member

My society has a Oracle 8i Database. If i Open DBAstudio i see two users 'BLAKE' and 'DBUSER' with the same tables, rows, everything.. If i create a new table for example 'table_employ' in'DBUSERS' i see two table_employ in 'DBUSERS'and two table_employ in 'BLAKE'... 4 table at all!! I want destroy blake and see only 1 table_employ... I'm afraid if i remove 'BLAKE' also 'DBUSERS' desappear ... and my job with it..!! How i can do?

Thank you...

Report message to a moderator

Re: Two users similar... which destroy? [message #102763 is a reply to message #102722]

Tue, 24 September 2002 03:22

shaheena
Messages: 17
Registered: February 2002

Junior Member

hello;
first export your required user to another database,then drop the user you don't want ,check the second one if it is not present ,import it from the clone database.
regards.

Report message to a moderator

Previous Topic:	Re: Oracle 8i New Features for Administrators
Next Topic:	All files managed by Oracle instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 22:40:53 CST 2024