Home » Other » General » Two users similar... which destroy?
Two users similar... which destroy? [message #102722] Tue, 10 September 2002 06:24 Go to next message
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...
Re: Two users similar... which destroy? [message #102763 is a reply to message #102722] Tue, 24 September 2002 03:22 Go to previous message
Messages: 17
Registered: February 2002
Junior Member
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.
Previous Topic: Re: Oracle 8i New Features for Administrators
Next Topic: All files managed by Oracle instance
Goto Forum:

Current Time: Thu May 23 10:47:44 CDT 2024