Re: SQL Developer Migration wizard

From: Lynne Flatley <lflatley@xxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
Date: Thu, 15 Oct 2020 06:37:07 -0400

I don't believe it has SYSDBA privileges but I can change that and I know
that the migration repository has at least one sequence. I'll see if I have
to tweak its definition.

This is a new migration project (created via SQL Developer 19.4).

Thanks!

Lynne
+JMJ+

On Thu, Oct 15, 2020 at 6:08 AM Frank Gordon <frankagordon@xxxxxxxxx> wrote:

Hello,

Does the user MIGRATION_REPO have SYSDBA privileges?

It may be that allowing NULL into the ID column causes problems later.
Is there a sequence that looks likely to be the source of the ID column.
Perhaps try changing the default value of the ID column to be that
sequence.

Is this a new or existing migration project?

Regards,
Frank

On Wed, Oct 14, 2020 at 5:22 PM Lynne Flatley <lflatley@xxxxxxxxx> wrote:

We have a MySQL database that we would like to convert to Oracle. I set
up SQL Developer (19.4) to use the MySQL jar file (5.1.29) so I am able to
view the MySQL schema and I can migrate tables by right-clicking on a table
or a set of tables and selecting Oracle copy but I would really like to set
a script that will migrate all of them via the script, i.e. not having to
manually right-click to initiate each table's conversion.

Using the migration project wizard, SQL Developer creates the migration
repository but when I try to run it, I get a constraint issue (null not
allowed)

[image: image.png]
ORA-01400 cannot insert NULL into MIGRATION_REPO.MD_PROJECTS.ID
<http://migration_repo.md_projects.id/>

I was thinking of removing the column constraint of not allowing NULL for
all tables in the Migration repository?

Thanks in advance for any ideas that you have.

Lynne Flatley
+JMJ+

--
+353-86-0695383

References:
- SQL Developer Migration wizard
  - From: Lynne Flatley
- Re: SQL Developer Migration wizard
  - From: Frank Gordon

Re: SQL Developer Migration wizard

Other related posts: