We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [sqldeveloper]

Oracle SQL Developer is a popular development environment for database architects.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 views

SSL certificate error when connecting to PostgreSQL database with Oracle SQL Developer on Fedora 30

For testing purposes I have a postgresql database running in a kvm virtual machine. It's part of the application I support for work, and I cannot make any configuration changes to the contents of the ...
0
votes
0answers
10 views

SQL Developer: Files won't open if SQL Developer already running

Having a slight strange issue, Oracle SQL Developer has suddenly stopped letting me open a new file if it's already open. If I've X'd SQL Developer off I can open a file no problem, but once this ...
0
votes
1answer
20 views

SQL Developer - how to assess change to data model

I'm working with a schema I'm not familiar with and am trying to find out if there is a way to do a diff between the state of the data in the schema instance between transactions - does anyone know if ...
0
votes
0answers
68 views

SQL Developer throws error,'Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection'

getting this error when trying to connect database on my laptop. ORACLE VERSION:- 11.02.00.01 sqldeveloper-19.2.1.247.2212-x64 OracleOraDb11g_home1TNSListener service if off new user, appreciate any ...
0
votes
0answers
29 views

sql developer can't open data import wizard

So, I want to populate a table with data from an excel file. I right click at my table and click on import data. I select the xlsx file that contains data, then a small chargement occurs after few ...
0
votes
0answers
238 views

Why does Oracle SQL Developer freezes (unresponsive) once I create a new connection?

I have only installed Oracle XE (the latest version 18g) and SQL Developer.
0
votes
0answers
86 views

oracle SQLDeveloper freezes on Mac when making a new connection

When making a new connection, the screen freezes and I am unable to close the SQL developer. I am running version 19.2.0 (JVM 1.8.0_221) on Mac OS Mojave 10.14.6. running bar freezes when connecting ...
0
votes
0answers
77 views

SQL Developer Edit view error 32k limit

I'm using SQL developer to connect to an Oracle DB. I have a couple of large views set up here. On the left hand side in the view explorer, when I right click and hit "edit" and I'm working from the ...
0
votes
0answers
32 views

Increase the Size of Icons and Texts in Oracle SQL Developer

How can I increase the size of the icons and text in Oracle SQL Developer?
1
vote
0answers
28 views

Illegal mix of collations error when attempting to view MYSQL table data in Sql Developer using connector/j 8.0.16

In SQL Developer 18.1, I'm trying to view table data in a third party mysql database, but receive the following error for all tables in all 8 schemas on the database. Illegal mix of collations (...
0
votes
0answers
222 views

SQL Developer 19: Connect to 18c XE not possible

I just updated my SQL-Developer from 4.x to 19.1.0.094. Connections to 12c-databases are working just fine, but I can't connect to my 18c XE-databases (running in a docker container). "Test"-button in ...
0
votes
0answers
150 views

Unable to connect user from SQL Developer to AWS RDS

I tried to connect to an AWS RDS that I created. I used SQL Developer to add the connection. I used the default SYSTEM user of Oracle. I have configured my tnsnames and listener files by adding the ...
0
votes
0answers
14 views

Unable to see DBA option in view / data pump option in SQL Developer

I can create a connection using DBA credentials, but I don't see the DBA option in the View menu in SQL Developer nor see data pump option in connections.
0
votes
1answer
140 views

How to change SQLDeveloper's language to Chinese?

I've seen many posts on how to change SQLDeveloper's language to English, by using the following method: sqldeveloper.exe --AddVMOption=-Duser.language=en I have tried this method with both English (...
0
votes
0answers
54 views

SQLDeveloper cannot connect to database

I am trying connect to an Oracle database (Oracle Database 11g Express Edition) on SQLDeveloper. I am doing this on Windows 10. Note that I am running it using Bootcamp since I have a Macbook (I don't ...
0
votes
0answers
58 views

Oracle SQL Developer Error when connecting to hive server

Status : Failure -Test failed: [Cloudera]HiveJDBCDriver Error initialized or created transport for authentication: java.net.ConnectException: Connection refused: connect. Error that we are getting is ...
1
vote
1answer
152 views

Oracle user - read only to any tables

I'm trying to add a user with read-only permissions to all tables. The problem is that after connecting to the database by SQL Developer, the tables (empty tab) do not appear on this user. Select on ...
0
votes
0answers
373 views

Oracle SQL Developer - load Excel file into sql server

I am trying to import Excel data into a table in SQL Developer. I have created table in SQL Developer. Then I use Data Import Wizard to import the Excel file into the table. The problem comes when ...
0
votes
0answers
178 views

sql developer query not stopping when cancel task button hit

when I am running a sql query and hit the stop button it does not stop the process and I have to wait until it finishes even after hitting cancel task button. Is there a setting that I have incorrect? ...
4
votes
2answers
8k views

Why can't I open SQL Developer when I have Java 10 installed?

In my Mac terminal: $ javac -version javac 10.0.1 I open SQL Developer and get this dialog: SQL Developer requires a minimum of Java 8. Java 8 can be downloaded from: http://www.oracle.com/...
0
votes
0answers
18 views

Is there a way to Store a Query in View/Procedures?

I wrote an Oracle query and I run it manually from SQL Plus or SQL Developer. It has 2 parameters; start and end date/time. Is there a way to store this query in a view or procedures and run it ...
5
votes
2answers
3k views

Improve SQL developer performance at query builder

I use Oracle SQL Developer (version 17.3.1.279) in Windows 10 64 bit. It's connected to an Oracle database in the network through TNS. Whenever I open "query builder" first time for a query, or after ...
5
votes
2answers
5k views

no Theme Selector on SQL Developer 17.3

I have been trying to change the theme of SQL Developer, and I am unable to find the theme selector under Environment in the preferences. has it been removed? Normally this is where it would be ...
3
votes
1answer
652 views

Prevent SQL Developer opening table design on click

I'm using SQL Developer 4.1.5.21 (under Windows 7 Professional 64 bit). (I've just downloaded latest version (17.3) and the issue is still the same.) Whenever I click or select a table name in the ...
2
votes
1answer
304 views

SQL Developer - Switch windows (not tabs)

SqlDeveloper for Windows has a nice feature where you can edit a .sql file, view a table, and see query results simultaneously (ie, divide your screen into 3 'panes', which can each hold an arbitrary ...
0
votes
0answers
359 views

Oracle Sql Developer - user interface (newbie)

I’m new to Oracle Sql Developer, I’m just searching for some explanatory guide or good video tutorial to explain basic principles of its interface, for example what is the difference between ...
3
votes
1answer
568 views

Oracle SQL Developer update

I am trying to update my Oracle SQL Developer 4.1.2.20. When I select components such as MySQL JDBC Driver or Perforce Extension then I am asked to log in using my Oracle Web Account. This is when ...
0
votes
0answers
1k views

Losing decimal places when exporting to csv

I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus ...
1
vote
2answers
783 views

What does this “3-line to column” icon indicate about an object in SQL Developer?

In SQL Developer, under Tables, almost all of my tables are just a normal table icon, however, every so often I come across a table that has the icon/image shown below. I wasn't around when some of ...
2
votes
2answers
2k views

SQL Developer 4 Toolbar

Recently my SQL Developer toolbar became messed up. I'm not sure what I did, and I can't change it back. When I got to View-->Show toolbars-->Customize Main Toolbar, it just says "initializing"...
2
votes
1answer
1k views

How to use backreferences in oracle sqldeveloper find/replace

How do you use backreferences when doing regular expression find/replace in Oracle SQLDeveloper? \n doesn't work for me and neither does $n.
2
votes
4answers
3k views

Oracle SQL Developer - How to add folders to frequently used locations in Open Folder interface

How do you add folders on the left side of the Open Folder interface? In one of my previous versions of the installation I had a couple different folders I frequently used in that part of the ...
1
vote
0answers
3k views

sql developer cannot establish a connection with db that does have listener running

I am working from home and connected to my work's vpn. I have tried to connect to the work db with sql developer (the latest version and the previous version) on the following environments: mac os x ...
4
votes
1answer
6k views

Export xls with dates from Oracle SQL Developer

Does anyone know how I can export an excel file from SQL developer with the fields formatted correctly? In particular the date and time columns. Thanks
2
votes
5answers
14k views

Sqldeveloper /as sysdba connection

I'm a total newbie in Oracle. I installed Oracle 11g XE R2. Also I installed SqlDeveloper 3.2.20.09 version. I generated auto connections, and I have 2 connections. One is: /as sysdba and another:...
5
votes
1answer
4k views

SQL Developer: Stop opening a new worksheet when connecting to schema.

Each time I connect to a schema it opens a new worksheet for that schema. Can I stop it doing this?
0
votes
1answer
3k views

Code folding in SQL Developer's SQL Worksheet

Is there a way to enable code folding in Oracle SQL Developer's SQL Worksheet? Using version 3.2.20.09.
1
vote
0answers
508 views

Unable to connect DB on a remote server

I have an OpenSUSE OS running under VirtualBox. I can connect to Oracle 11g database with SQLDeveloper from localhost, but when I try to connect it from another PC I have either Io exception: Got ...
1
vote
1answer
3k views

Connect using sqlplus to db server through multiple tunnels

I would like to create an SQL Developer connection to a database through a couple of tunnels. The steps right now are: Connect to server A -> connect to server B -> run sqlplus against tnsname on a ...
7
votes
3answers
17k views

How to increase memory footprint of SQLDeveloper

I want to use SQLDeveloper with files that are fairly large. However, performance is sluggish (at best) due to a lack of memory. Assuming that it is a Java app, how can I increase the size of memory ...
2
votes
2answers
16k views

How do I export the data from an Oracle SQL Developer query

How do I export the data from an Oracle SQL Developer query? I can create queries in it fine, but as to export?
20
votes
4answers
54k views

Is there a way to configure the directory SQL Developer uses to save SQL scripts?

Is there a way to configure the directory SQL Developer uses to save SQL scripts? When I do ... File, New, SQL File ... the directory is always set to the \AppData\Roaming\ for my user. I'd like to ...
10
votes
13answers
154k views

SQL Developer Error Messages: “Enter the full pathname for java.exe” and “Cannot find a J2SE SDK installed at path”

Yesterday, I downloaded SQL Developer 3 with SDK and was able to use it just fine. After shutting down my PC last night and booting it up again this morning, every time I try to run it, I get this ...
2
votes
3answers
1k views

Free software to replace SQL Developer?

As for a developer, the use of SQL Developer is almost daily. However, given that my laptop have only 1 gb ram, it is hard to open SQL Developer and Eclipse together. Do you have any lighter ...
1
vote
0answers
3k views

SQL developer won't start

Today I tried to open SQL developer and it won't start at all. I am using Windows XP and I haven't been using SQL Developer for 1 or 2 months. Today, when I tried to open SQL Developer, I click the ...
8
votes
8answers
10k views

Is there a shortcut to switch between tabs on Oracle SQL Developer?

I'd like to be able to switch between 'Query Result' windows, and it's a pain having to use a pointer (mouse/touchpad) each time.
20
votes
2answers
28k views

How to open several tables in different tabs in SQL Developer

I have several schemes and need to open different tables in different tabs from different schemes at the same time. SQL Developer opens the table view in the same tab. Clicking whilst holding Ctrl ...
4
votes
6answers
25k views

Ctrl v does not work in ORACLE SQL Developer

I cannot get paste (Ctrl+V) to work in Oracle SQL Developer.
1
vote
1answer
3k views

Oracle SQLDeveloper locks up when using copy/paste

SQL Developer keeps locking up when I copy/paste text in a worksheet. It happens when I past into SQL Developer from itself or from another application and also when I past from Developer into ...