DB2 Database Export in Oracle SQL Developer gives an empty connection list

Question

I need to backup my DB so I use Tools --> Database Export. However, when I want to choose my connection I got no connection in drop down list.

Just to mention that I can see my connection list in "Connections" tab and also all connections in "C:\Users{MyUser}\AppData\Roaming\SQL Developer\system3.0.04.34\o.jdeveloper.db.connection.11.1.1.4.37.59.31\connections.xml" file

Same behavior happens also in "Database Copy", "database Diff" and in "Monitor SQL"

Any idea ?

Thanks in advance

That version is so old...it's like from 2010. Also, if you want a backup of your database you should use rman or data Pump — thatjeffsmith
– thatjeffsmith, Commented Nov 14, 2019 at 14:12
Also that feature is for Oracle only...if you're trying to use it for MySQL, SQL server, db2...that's why they're not showing up — thatjeffsmith
– thatjeffsmith, Commented Nov 14, 2019 at 14:13
if it's DB2, you need to use your DB2 interfaces to get a good backup - that would not be SQL Developer. — thatjeffsmith
– thatjeffsmith, Commented Nov 14, 2019 at 14:33

thatjeffsmith · Accepted Answer · 2019-11-14 14:34:58Z

1

The Database Export feature is built for Oracle Databases only. That's why you aren't seeing your DB2 connections in the Export, Copy, or DIFF wizards in ORACLE SQL Developer (keyword, Oracle).

If you want to backup your IBM DB2 database, you need to use the tools that IBM gives you for managing DB2.

answered Nov 14, 2019 at 14:34

thatjeffsmith

22.7k6 gold badges44 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DB2 Database Export in Oracle SQL Developer gives an empty connection list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related