In message <1108634443.440595.83000_at_c13g2000cwb.googlegroups.com>,
TheanKeong <theankeong_at_gmail.com> writes
>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 ?
>
You can edit the scripts produced by the migration workbench and change
all references to dba to something sensible.
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Thu Feb 17 2005 - 15:47:16 CST
