This content has been marked as final. Show 15 replies
good question, if there is no way to use it with 10g databases this is strange because
Oracle Database Certification
Oracle Database 11g Release 2
Oracle Database 11g Release 1
Oracle Database 10g
Oracle Database Express Edition 10g
Oracle TimesTen In-Memory Database 11g
Oracle In-Memory Database Cache 11g
so what i have todo to use "Oracle Database Express Edition 10g"?
As similar to some of earlier posts here, after I selected the TOOLS | DATAMINER | MAKE VISIBLE then I can no longer use SQL Developer 3.0 to connect to target DBs (i.e. 10.2.0.4 version) using any previously working connections. Win XP (SP 3).
I have not been able to find any method to DE-ACTIVATE the Data Miner option in the TOOLS menu (to de-select the 'MAKE VISIBLE' option), which is very frustrating. I considered trying the 'DROP REPOSITORY' option, but that seemed risky.
So I deleted the entire SQL Developer 3.0 folder/files from the disk drive, then did another fresh UNZIP of the SQL Developer 3.0 folder/files. But when I ran the freshly unzipped executable "sqldeveloper.exe" file, it immediately gave me the message in a CONNECTION INFORMATION window "Data Miner is monitoring workflow jobs on connection 'xxxxxx'." and none of the DB connections (i.e. for version 10.2.0.4) work because the message says an 11.2 target DB is required.
1. How can the DATA MINER option be reverted in SQL Developer 3.0?
2. Is there a Windows Registry entry that can be changed?
To completely clear all the persisted settings for SQLDeveloper, you need to backup/delete the SQLDeveloper system folder, usually stored in:
Win 7this will remove all your settings and the system folder will be recreated from scratch when you start SQLDeveloper.
documents and settings\%USERNAME%\Application Data\SQL Developer\systemXXXXXX
I never used the data miner option so far, so i cannot say if there is a quicker way to disable it, but deleting all the settings will do the job for sure.
Thanks very much.
Your suggestion to delete my Win XP folder (documents and settings\%USERNAME%\Application Data\SQL Developer\systemXXXXXX) worked great.
After that I started up SQL Developer 3.0 and it asked me the fresh question if I wanted to import old settings (I answered 'yes') and I was back to normal.
I will avoid the "Tools/Data Miner/Make Visible" from now on.
I just hit this same problem. Took me a while to figure out what was going on.
I upgrade to SQL Developer 3.0, and continued using it as usual for a while. I then decided to see what new features had been added, which included clicking the Data Miner->Make Visible option, resulting in then getting the error reported in this thread.
Here's what causes the confusion. The only obvious change to the interface is the addition of the Workflow Jobs tab below the Connections tab. So, the obvious way to get rid of it is to close the Workflow Jobs tab.
Here's the thing, another tab has also opened. You end up with "Connections", "Reports", and "Data Miner" tabs. The "Data Miner" tab looks almost identical to the Connections tab. That's what confused me (and I suspect is what's confused other people too). The only difference between the two tabs is that the icons on individual connections are slightly different, and the data miner tab lacks the "apply filter" button in the tab's toolbar. Closing the Data miner tab and going back to the Connections tab got everything working again.
Frankly, it's terribly confusing UI design to have two tabs which look so similar, but do different things.