I get this message in the migrationlog.xml when attempting to migrate from sybase to oracle 12c. the sybase objects seem to migrate by the tables/views are blank so the data migration seems to be failing.
I see this error message in the migrationlog.xml file:
<message>syb_mig_user.dbo.CashFlow ORA-01950: no privileges on tablespace 'USERS'
where syb_mig_user is the sybase db name and is the oracle user that sqldeveloper automatically creates via the master.sql right before setting up the emulation user id.
i know that fixing this error is addressed by granting unlimited quota on the USERS tablespace, but I can't since this user is automatically set up by sqldeveloper so setting up the user beforehand will not help since it seems to be dropped/recreated anyway by sqldeveloper during the migration process. Any ideas?
From master.sql:
-- PROMPT Drop syb_mig_useruser
-- drop user syb_mig_usercascade;
PROMPT Create user syb_mig_user
CREATE USER syb_mig_user identified by &&syb_mig_user DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM TO syb_mig_user;
-- PROMPT Drop Emulation user
-- drop user Emulation cascade;
PROMPT Create user Emulation
CREATE USER Emulation identified by &&Emulation_password DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM TO Emulation;