Description:
Workbench Migration wizard doesn't retrieve any objects from Oracle. Connecting Oracle user has following Privileges/roles.
DBA
SELECT ANY DICTIONARY
select_catalog_role
How to repeat:
Source Database:
1) Add ODBC connection using "Open ODBC Administrator"
2) database system : Generic RDBMS
3) Connection Method : ODBC data source
4) Test Connection (successful )
5) Press <Next>
Target Database :
1)Stored Connection : <pick MYSQL >
2) connection method : Standard (TCP/IP)
3) Test Connection (successful )
4) Press <Next>
Fetch Schema list:
1) connect to source DBMS : okay
2) check target DBMS connection : okay
3) Retrieve schema list from source : okay
Finished performing tasks
Click <Next> to continue
select the schema you want to migrate :
<empty list>
Logs:
Starting...
Connect to source DBMS...
- Connecting to source...
Connecting to ...
Opening ODBC connection to DSN=DW_RECONIN...
Connected
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
Connection to apparently lost, reconnecting...
Connecting to ...
Opening ODBC connection to DSN=DW_RECONIN...
Connected
- Fetching catalog names...
- Fetching schema names...
- Finished
Retrieve schema list from source finished
Finished performing tasks.