1 Reply Latest reply on Jan 29, 2013 7:57 AM by clementeOTN

    sql developer data move

    11g.DBA
      Hi all,

      I was migrating a test database(mysql) to an oracle database.
      I created a user and gave the following rights to it.

      GRANT CONNECT, CREATE SESSION, RESOURCE, CREATE VIEW, CREATE PUBLIC SYNONYM TO migrations WITH ADMIN OPTION;
      GRANT ALTER ANY ROLE, ALTER ANY SEQUENCE, ALTER ANY TABLE, ALTER TABLESPACE,ALTER ANY TRIGGER, COMMENT ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY TABLE,CREATE ANY TRIGGER, CREATE ROLE, CREATE TABLESPACE, CREATE USER, DROP ANY SEQUENCE, DROP ANY TABLE, DROP ANY TRIGGER, DROP TABLESPACE, DROP USER, DROP ANY ROLE, GRANT ANY ROLE, INSERT ANY TABLE, SELECT ANY TABLE, UPDATE ANY TABLE TO migrations;
      Commit;

      Whole process completed successfully,Even the project details are showing everything(capture,convert,generate,data move) as complete but no new tables are visible in the oracle database.
      Tried bouncing the database but no use.
        • 1. Re: sql developer data move
          clementeOTN
          With those commands you have just granted privileges to the user.
          Now you can create table and import data (and you will see it)

          If you inserted/imported "migrations" databefore with another user, you will not see this data in the "migrations" schema (schema is Oracle's name for mysql user ) .
          You could reference this data as anotheruser.tablename (if you inserted/imported the data with "anotheruser") ,but, the best way is import/insert the data in his own schema.