DBA user in Oracle conflicts during migration

From: TheanKeong <theankeong_at_gmail.com>
Date: 17 Feb 2005 02:00:43 -0800
Message-ID: <1108634443.440595.83000@c13g2000cwb.googlegroups.com>

Hi,

I am trying to migrate my DB from Sybase ASE to Oracle. When i try to use WorkBench to migrate my db, i encountered some problems of the following

i) Cannot create the user of 'dba'. I know that Oracle has a Role called dba and therefore my user cant be created. Is there any workaround to enable my user ('dba') to be created in Oracle?

ii) I need to migrate my tables into Oracle DB, unfortunately all my tables are created and owner by the user 'dba'. Since Oracle disallowed me to create the user, what should i do ?

Is there any workaround to have my user of 'dba' created ?

Thanks
TheanKeong Received on Thu Feb 17 2005 - 04:00:43 CST