When downloading software to my database server, I used to first download locally and later copy to my Unix box… but wouldn’t be convenient to download it directly on the database server? Quite often, you get no X and no Browser and no Internet access on your datacenter. Therefore, we’ll use wget to the purpose.… Continue reading Download Oracle software with the command line
Oracle SQL Developer provides access to data and code from other database systems than Oracle If you run Sybase procedures (or Microsoft SQL Server I suppose), you cannot use the BEGIN / DECLARE / EXEC in anonymous blocks begin print ‘HELLO’ end Error starting at line : 1 in command – begin print ‘HELLO’ end… Continue reading execute Sybase procedures from Oracle SQL Developer
The release V4.0 of sql developer is available for download : oracle.com/technetwork/developer-tools/sql-developer/downloads The doc is there : docs.oracle.com/cd/E39885_01/index.htm And read Jeff Smith twit’s and blog I requested some time ago a 64bit Windows version with JDK on Oracle SQL Developer Exchange and once again it got accepted. Okay, I have on my PC two Oracle… Continue reading Configure ORACLE_HOME for SQL Developer
It is highly probable you already have MS AD in your company. Probably you use a local tnsnames.ora. Apart from setting a Oracle Internet Directory or Oracle Virtual Directory, there is one more option that you may want to consider : AD. Ok, here is a bit of a road map : – Schema Extension… Continue reading TNSNAMES and Active Directory
I got this question once again today in a previous post. What’s wrong by using Toad against a database? The worst case scenario: – some non-technical staff is clicking around in your production database with read-write access 🙁 The best-case scenario : – nobody has access to your database 🙂 Here is a short list… Continue reading On using Toad against a database
Historically and semantically, SQL Developer is a developer tool. There is very little comparison with TOAD for the dba. But… Oracle is working on this! In the latest release, 3.0 EA1, you will be able to see Tablespaces, Redo logs and controlfile, finally. Still no session browser, but I am delighted that the database administrators… Continue reading SQL developer for dba
Sue Harper is the product manager for Oracle SQL developer. She is also the author of a book, Oracle SQL Developer 2.1 . A bunch of Oracle blogger received a free online version of the book with the task to write a review. I have read a few chapters and here are my general comments.… Continue reading Book review: oracle sql developper
I just downloaded and installed osdm Have a look at my first screen of the ERD generated from my Scott schema
check Oracle SQL Developer 1.1 Evaluation Release is Now Available! PS: there is now a RPM for Linux, which I installed on my SLES 10 notebook with SUN JDK 1.6.
Well, it is now renamed to SQL Developer. There is now an expected “Save password” checkbox to save the password… apart from the name, it looks quite similar to raptor 😉
raptor product page I have not checked the differences with 3.0 yet, probably bug fixes with “do not save passwords”
This is THE release I have been waiting for, a raptor which does NOT save the password on your local PC. Save a password, even encrypted, on you local PC allows every one with physical access to your PC to get access to your productive database, which may be high-secured and with controlled physical access.… Continue reading raptor early adopter release 3 is out
a few improvement described in the readme.txt. One of this is big-tnsfile support. always missing is a way to NOT SAVE the password on the client!