SQLdev 4.2 - Does not coping data

I am having issues copying data from one instance to another - tables are created but the data does not get copied across

Are you saying the data is not copied and you get no error messages explaining why it fails?  That would be rather strange.

Further to this, I can still copy data when using version 4.1.5.

Would the successful copy using 4.1.5 be using the same source and target connections?  I assume you are using Tools > Database Copy...

If so, then the Summary page should look something like...

In my test case, I created an empty schema (SCOTT_CLONE) on a remote 12.2 instance and used Database Copy to copy two tables from user SCOTT on a local 11.2 XE instance to the remote instance.  Both the DDL and insert DML ran fine.

The target connection user SCOTT_CLONE was only granted...

1. Connect role.

2. Resource role.

3 Unlimited tablespace system privilege.

If this differs from your use case, please post information from the Database Copy log tab.  If nothing is showing up there, you might have to start SQL Developer (the ...\sqldeveloper\sqldeveloper\bin\sqldeveloper.exe) from the command line to see any error messages that appear in the console.

Hi Gary, yes, the tables are created with not data copied.

Please REREAD the reply and answer ALL of the questions you were ask.

what command line option?

Not an option, but opening a terminal window (Cmd window on Windows).  Something like...

and you should get a Database Copy results tab as shown above.

In my case, switching to all tables, all views, all materialized views, the next statement in the log sequence after the MDSYS.all_sdo_geom_metadata is...

select constraint_name from user_constraints where constraint_type = 'R' and table_name =:NAME  "NAME"="DEPT

I suppose the standard advice applies here: trying renaming or deleting the system<sqldev-version> under the SQL Developer user settings folder, restart SQL Developer without migrating settings from a prior version, then try the Database Copy again.  Rather than Database Copy, you can try drag 'n drop of a table across instances and see if that works.

Do you co-workers see the same problem?

Have you tried just copying a single table vs an entire schema?

Does Tools > Database Export work?

OK I have downloaded SQL Developer again and the data does not copy. The Statements - log stops at

 

2020

RACI Prod

47

select count(*) from MDSYS.all_sdo_geom_metadata where OWNER = 'RACI'

null

 

Ok - then it it time to:

1. post the full source table DDL - table, indexes, constraints

2. post the full target table DDL - table, indexes, constraints (the DDL of the table that is actually created that SHOULD, but might not, BE a clone of the source

3. sample data from the source table - post at least 1 row

4. results of MANUALLY trying to insert  the one row from #3 above

My question would be why a COUNT(*) is being done from the MDSYS schema.

There may be a privilege issue. The data may be getting inserted into a DIFFERENT table with that same name because of a synonym.

no, that's been in the tool for years, you're prompted to opt into sharing usage details so we can help improve the product

You can control this feature via Tools > Preferences > Usage Reporting > Allow automatic usage reporting to Oracle.