- i created connection to mssql in Oracle SQL Developer Tool (autentication via OS user) on windows machine
- i created connection to oracle 10g(other server/machine ) in Oracle SQL Developer Tool (autentication via OS user)
- i highlight pubs and press export to oracle
- result is :i can't see in oracle on mika user any table from pubs and in DBO_PUBS user i cannot see table from mssql (take a look in picture like below)
DBO_PUBS was created in ORACLE during migration process.

SQL> select * from dba_sys_privs where grantee like '%MIKA%';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
MIKA CREATE VIEW NO
MIKA CREATE USER YES
MIKA ALTER ANY SEQUENCE NO
MIKA UNLIMITED TABLESPACE YES
MIKA ALTER TABLESPACE NO
MIKA ALTER ANY TRIGGER YES
MIKA CREATE ANY TABLE YES
MIKA DROP ANY SEQUENCE NO
MIKA CREATE ROLE YES
MIKA CREATE TABLESPACE NO
MIKA ALTER ANY TABLE NO
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
MIKA SELECT ANY TABLE NO
MIKA INSERT ANY TABLE NO
MIKA GRANT ANY ROLE NO
MIKA DROP ANY TRIGGER NO
MIKA DROP TABLESPACE NO
MIKA UPDATE ANY TABLE NO
MIKA CREATE ANY SEQUENCE NO
MIKA COMMENT ANY TABLE NO
MIKA DROP ANY ROLE NO
MIKA CREATE SESSION NO
MIKA DROP USER NO
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
MIKA DROP ANY TABLE NO
MIKA ALTER ANY ROLE NO
MIKA CREATE ANY TRIGGER NO

I think no , i grant roles acording to manual\help cener from Oracle SQL Developer Tool:

"For example, you can create a user called migrations with the minimum required privileges required to migrate a database by using the following commands:
CREATE USER migrations IDENTIFIED BY password
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;