Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Server 2000 -> Oracle 8.1.x migration using OMWB
OMWB is Oracle Migration Workbench....it's a product specifically made
for migrating databases from non oracle DB's to Oracle. but it seems
to be a pain.
Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CFD4D94.5DF2580F_at_exesolutions.com>...
> MT wrote:
>
> > I've got a 58 table database in sql server 2000 trying to migrate to
> > Oracle. during the migration process OMWB hangs everytime on the same
> > error message:
> >
> > "failed to map user privilege :
> > User "" was unable to grant a "EXECUTE" privilege to "user1" for a
> > "PROCEDURE" in the "My_DB" database."
> >
> > note: user1 is actually a user's name.
> >
> > anyone have similar problems? thanks
>
> What is OMWB?
>
> The migration would likely be a lot easier if you dumped everything in
> delimited ASCII and used SQL*Loader.
>
> Daniel Morgan
Received on Wed Jun 05 2002 - 13:16:23 CDT