Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Server 2000 -> Oracle 8.1.x migration using OMWB

Re: SQL Server 2000 -> Oracle 8.1.x migration using OMWB

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 04 Jun 2002 23:30:34 GMT
Message-ID: <3CFD4D94.5DF2580F@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 Tue Jun 04 2002 - 18:30:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US