Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
7,937 Comments
Hi Jeff,
Rather new to SQL Developer Data Modeler… but have created ERD before. I download 4.0.X and have installed without attaching it to db. I’ve just started designing by adding objects and creating relationships.
My question pertains to deleting objects (Entities). I’ve created a Logical Model with a number of objects and relationship. When I delete a object or relationship I from the Logical model the entity object is removed from the diagram but it (entity / table) does not get deleted from the design.
Here’s the strange thing – when I delete it the label turns red… after saving the model, closing and opening – eveything is back in the design as if I hadn’t deleted it. It’s no longer on the model but if I try and drag and drop the “deleted” entity to the model – it appears to work, until I save and re-open the design… then the object is not on the logical diagram! What I want is to clean up the design so that only the entities on the model are in the design (left hand pane/browser).
I’ve found a few crumbs that suggest it has something to do with sync’ing deletions… but like I said, I’m not connected to a database. Any help would be most appreciated.
are you actually deleting it from the design, or are you just removing it from the diagram?
4.0.X – exactly what version?
You could try 4.1.1 – that’s the latest and greatest version.
Sorry – version 4.1.1. I have been deleting the objects from the logical model diagram. Right click, delete.
However I notice that the entiy continues to persist in the design. So I attempted to delete it there (the reason is when I create a PDF report I don’t want to see the objects the no longer exist in the model).
This is where it get confusing. After deleting the object and closing the desig an reopening the object is still there. I’ve tried a different computer thinking that maybe it was the install – but it has the same behavior. So it’s likely working as it should. Help would be appreciated.
Can you post this to the Forums or open an SR with MOS?
Thanks will do.
Is there any way to attach a link to an entity in data modeller, so when generating a pdf data model, clicking on a link would send me to … eg an apex application.
Currently I am doing this with visio…
Is there any way to customize datamodeller attaching a link to an entity ?
no, the closest you could get would be to add the URLs to your entity notes field, and then copy & paste…but you’ve given me an idea
we created links that lead to an apex application where the user could directly display and modify table/column comments in the oracle database … so an enhancement request and a very good feature, cause the users know a lot more about the buisness than we do.
Within the past couple of days, SQL Developer has started shutting down when I remove my laptop from the docking station and go to another part of the building. I’ve usually lost the database connection in the past, but I’m not sure why the entire application is closing without any type of warning. Any ideas as to what might be causing this?
Thanks,
Darryl
Version 4.0.0.13
Build MAIN-13.80
Darryl, I hate to be that guy, but…can you try upgrading? We’ve had 3 patches for 4.0, plus 4.1, and 4.1.1 come out since 4.0.0 was released.
Does anybody know where/how to associate Information Stores with Entities/Attributes?
Or has this function been disabled?
Thanks a lot!
Kurt
PS: in Version 4.1.0.866
Hi Jeff,
I installed Oracle Developer 11g on my MAC and have updated my java aswell. When i try to connect to the database i get the error
” IO Error: The network adapter could not establish the connection”.
I have tried connecting Oracle developer 11g on my windows and it works with the same credentials. But always gives me error on my MAC.
Please help.
Thanks
can you connect with sqlplus as SYS on your mac?
i have no idea what your connect string is, so I can’t begin to guess what your problem is
Hello Jeff
Where/How do I associate Information Stores with Entities/Attributes?
Thanks a lot
Kurt
PS: in Version 4.1.0.866
Im trying to reset my password because it is expired
I downloaded the install client file 64 bit for my 64 bit computer and putted its path in path in environment variable
also , i checked on use oracle client and use oci/thick driver
and determined the client location
whether i configure it as oracle home or instant client
it gives me this error “ojdbc6.jar is not a valid jar file”:
Testing the Instant Client located at E:\app\ACER\product\11.2.0
Testing client directory … OK
Testing loading Oracle JDBC driver … Failed:
E:\app\ACER\product\11.2.0\ojdbc6.jar is not a valid jar file
———————————————————————————————–
Testing the Oracle Home located at E:\app\ACER\product\11.2.0
Testing client directory … OK
Testing loading Oracle JDBC driver … Failed:
E:\app\ACER\product\11.2.0\jdbc\lib\ojdbc6.jar is not a valid jar file
How this can be solved?
Regards.
Hello Jeff,
Will anyone would like to work with EE and Tuning Pack , lot of my customers are on SE or SE1 without any Pack or options. From that point some of the very interresting reports on SQLdeveloper still made some “bad” select to v$active_session_history (Diag Pack) . Look at “sessions report” the child for “Explain plan” is using it . As a WO we can made our own custom reports , but to avoid any misplaying could we remove one of your kindly delivered reports ? Same logic in “Tools” where “Sessions survey” is there and made this select on ASH . Can’t see option to remove it ? I’m using release 4.1.0.9 build 19.07. Looking forward to hear from you. Regards
Hello Jeff,
The requirement is to migrate schema objects from one oracle db to another oracle db. The schema objects should exclude triggers,sequences,constraints.
Can we select the objects in the screen manually,which we want to migrate only?
I am asking this because I don’t have the SQL developer installed now. So before proposing this tool to my client,I want to get a confirmation from you.
Appreciate your help.
Most definitely, Tools – Export. Choose the types of objects you want scripted. Optionally choose the specific ables, views, etc. you want included.
Thanks Jeff for your reply.
Does that mean either in offline or online mode,I can restrict the selection of schema objects to be migrated?
There is no offline mode? You need a connection to generate the scripts.
Hello Jeff,
Thanks for your reply,
Can you please confirm me which version of Oracle SQL Developer should I be procuring to get the Migration Wizard ?
Thanks
Sutanuka
the latest version you can find on OTN, 4.1.1
Hi Jeff,
I simply can not figure it out, I hope you can help me. We would like to neatly format the SQL code, thus we ask.
1. Why there is always a line break between insert and into?
2. No matter what you do, there is always line break in the values section of insert;
3. We would like to have all variables lowercase, table name lowercase and special keywords uppercase, can this be done?
On vacation this week. Since I can’t answer this one off the top of my head, I’ll take a look at it first thing next week. Or maybe 2nd or 3rd thing.
Hi Jeff,
Any ideas on how to achieve the formatting requirements which I posted earlier?
1. Just how it is today – and I don’t seen a preference to override this, sorry
2. Not true, Formatting Preferences, Line Breaks, ‘Number of Commas per Line – increase from ‘1’
3. Not that I can tell. You have a bit more flexibility with this outside the formatter. See the last section of this post
Hi Jeff,
I was wondering if you knew how to get the SVN that is embedded in SQL Developer to use Windows authentication rather than username/password? We log in with a smart card and we do not have individual login ids / passwords so we are stymied at the SVN login credentials screen.
We use SQL Developer 4.1.0.19 and Tortoise/SVN 1.7.13 – 64 bit on Subversion 1.7.10. Our repository is on a server, not a local machine.
Thanks for any suggestions!
Not sure if you can. We use the SVN integration that comes from JDeveloper – try searching their OTN Community Space for this topic to see if there’s an undocumented way to get what you want.
This isn’t so much a question as a bug. When you try to connect to a database and your database password is close to expiring then you get a “java.lang.ArithmeticException: / by zero” error. It is a very confusing bug to run into. To get around it you can either reset your password or right click on the connection, click properties, and then click connect.
What version of EVERYTHING are you using? Database, client, Java, OS, and of course, SQL Developer.
I am exporting about 8 million records in SQL Developer, I want to know the time taken to export these records, similar to the time taken for a query(“Fetched 50 rows in 0.023 seconds”). How to enable/view the time taken for exports?
You can watch the progress/timer in View > Task Progress
Is there a way to change the pop-up window ‘VIEW VALUE’ to a fixed font ?
Hey Jeff,
I’m trying to create a job (in SQL Developer 4.x) that runs a stored procedure within a specific time on a 45 minute interval on business days. I noticed that this job disappears/gets deleted automatically after it’s first successful run. Note that “Auto-drop” is FALSE and “Restartable” is TRUE. Am I missing something? Is this a bug? (Oracle 12.1.0.2.0)
Part of the job creation’s PL/SQL:
DBMS_SCHEDULER.CREATE_JOB (
job_name => ‘”USER_SCHEMA”.”JOB_01″‘,
job_type => ‘STORED_PROCEDURE’,
job_action => ‘OUT_PROC’,
start_date => TO_TIMESTAMP_TZ(‘2015-06-22 09:30:00.000000000 ASIA/JAPAN’,’YYYY-MM-DD HH24:MI:SS.FF TZR’),
repeat_interval => ‘FREQ=MINUTELY;INTERVAL=45;BYDAY=MON,TUE,WED,THU,SUN;BYHOUR=9,10,11,12’,
end_date => NULL,
enabled => FALSE,
auto_drop => FALSE,
comments => ”,
job_style => ‘REGULAR’);
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => ‘”USER_SCHEMA”.”JOB_01″‘,
attribute => ‘restartable’, value => TRUE);
DBMS_SCHEDULER.enable(
name => ‘”USER_SCHEMA”.”JOB_01″‘);
END;
Side note: Appreciate the effort you put in this site, it made me prefer SQL Developer from the command line! Wishing you all the best.
that LOOKS right to me
I would file an SR with My Oracle Support.
Hi Jeff,
excuse me, I’m insiting on my question two days before: How do I change the encoding / character-set in the cart-export-tool? It’s by default cp1252, but I need ISO 8859-1. There is a dropdown, but it only displays “loading” if I open it. What do I have to do?
Best regards
Christoph
Insisting? I was at a conference all week, sorry for not replying as soon as I saw this.
The only displays ‘loading’ when you click on it isn’t a good thing. That’s Java asking your OS for a list of supported file encodings I’m pretty sure.
Tools > Preferences > Database > Utilities > Export. Set the encoding there. That will now be the default. I confirmed this in 4.1, setting Encoding to UTF8 in preferences, then exporting table from cart, dialog is set to UTF8 encoding.
Hi Jeff,
thank you for your answer – and I apologize for my impatience. Well, waiting is hard – not even for Christmas Eve ;-).
I could fix the problem. Our IT-Service installed SQL-Developer not at “C:\” so the program could not find the other encodings. Now on “C:” it works fine.
Now I wish you recreative holidays, fun and sun at the beach.
BR
Christoph
Ahhhhhhh. Good info to have. That COULD be a bug on our side. I’ll look into it, and I’ll definitely file this in my ‘weird stuff’ bucket for the next customer that runs into it. Thanks!
Jeff,
Thank you very much for your reply, i’ll stop looking for a solution in this way.
Have a good day.
I’m new using sql developer. My problem is: I need to use the proxy server and when I click in any option sql developer just freeze. (I have to kill the process).
I’m using windows 7 8gb ram. The freeze only occurs when using the proxy and I need to use it.
Hi Jeff,
I would like to change some settings to prevent SqlDeveloper’s users to ADD new connctions or to modify existent ones (with + or with right click on connection). I want that they only use the connections i configured in a TNS file.
Can you please say me if it’s possible and if yes how to do that.
Thank you in advance
SqlDeveloper : 4.1.0.19
JDK : JKDK1.8.0_45
Oracle Database : 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
You could replace their connections.xml file every time they do an application startup just to mess with them for not behaving, but there’s no way you can prevent them from connecting once it’s open.
They could always do a CONNECT user/pass@host… in the worksheet too, so even if you did find a way, they’re still gonna have options.
Jeff,
I’m struggling to get the debugger to work using an SSH tunnel set up in PuTTY. I have posted a question on OTN, but have so far not received any replies. Can you help?
Here’s a link to my question:
https://community.oracle.com/message/13115998
Kind regards,
Guy
you need a remote port forward from your database server back down to your machine
you can do this in sqldev now using our integrated SSH tech if PUTTY is giving you problems
hi!
on this page http://www.thatjeffsmith.com/archive/2014/09/30-sql-developer-tips-in-30-days-day-17-using-ssh-tunnels/ i learned how to setup an oracle connection through a ssh tunnel.
how can i do the same for DB2 or MSSQL connections?
(i am using sql developer version 4.1.0.19)
rgds,
karner
View, ssh. Create a port forward. Define a regular connection to that port on your machine, using localhost.
hi jeff!
that’s what i have been doing up until now with all connections but via putty . i am using putty with port forwarding and am editing the hosts files (i am working on windows).
i am searching for a way where i can use use original hostnames and ports for all my connections where i need to go through my ssh tunnel.
the reason for this is that i have approx 5-10 database connections in a java project for 4 different environments (dev,prod, int, end2end).
furthermore the application will also make soap calls which need to be done via ssh-tunnel.
i was trying to get sql-developer and tomcat started with socksProxyHost+Port jvm-flags configured but i failed getting it working for both.
so basically everyhing in this project should go via ssh tunnel.
if you have any suggestions that would improve the current situation, i would be grateful!
thanks,
karner
Hi Jeff,
I am having problems with 4.1.0 sometimes (quite often) hanging at the “Restoring Windows” stage when loading. I just keep re-trying and eventually SQL Developer opens. I am sure it is to do with my Java as I installed Java 8 but as it messed up everything else I copied the directories and then un-installed it. I pointed SQL Developer at the copied Java 8 home. I guess I have two questions:
1) do you have any release date for SQL Developer 4.1.0 bundled with Java (for Windows)
2) are you aware of anybody else having this problem and if so have they sorted it or would you like me to raise a Service Request to log the issue?
I really love SQL Developer and it keeps getting better with each new release, keep up the good work!
Hi Jeff,
since my last question half an year ago I use SQL Dev. with success and comfort. Now I have to setup a new task and therefore a new question. How do I change the file-encoding in the cart export? It’s Cp1252 by default, as you know ;-). But I need ISO-8859-1 (Latin-1). I can change the character-encoding in preferences, but if I open the dropdown, it only displays “loading” and nothing more happens. It’s the same in the export-tool. If I try to change the encoding, the dropdown only shows “loading”. How do I have to implement another character-set?
Best regards from Germany again,
Christoph
Is there a way to make Oracle SQL Developer 4 work with Subversion using Windows Authentication rather than Basic?
Hi, Jeff,
another problem I have with sqlcl – I am sure I am doing something wrong – but when I set feedback off I still get feedback when “no rows selected”. If any rows are selected, there is no feedback, as it should be. Any ideas?
Thanks!
Kate