After Migration, where to find the migrated tables?
399603Jul 22 2003 — edited Jul 30 2003Hi,
I'm new to Oracle and the MWB. I installed MWB and followed the UserGuide to run it. It captured the source database(MSSQL200), and migrated to Oracle database. However, when I went into Oracle using OEM, I couldn't find any tables that should have been migrated.
In MWB, I can see the source DB shown on the Source Model tab, and one new object in tablespaces on the Oracle Model tab. The first time after I migrated, the icon next to the new object in tablespace is a blueish database. When I tried to migrate it again, it gave me an error saying tablespace already existed. I chose "ignor error" and continued. When it's done, the icon next to the new object was covered by a red squre with a red cross inside of it.
Can anybody tell me what was wrong and what else I need to do to get all the tables be available through OEM?
Thanks.
(btw, there were some errors during the capturing and migrating. Here are a couple of the error messages:
failed to map table :
1. oracle.mtg.migration.MigrationSQLException: ORA-01400: cannot insert NULL into ("REPUSER"."OM_OBJ_INFO"."OBJ_OWNER") :ORA-01400: cannot insert NULL into ("REPUSER"."OM_OBJ_INFO"."OBJ_OWNER")
2. Failed to create role:
ORA-01921: role name "DB_ACCESSADMIN" conflicts with another user or role name
)