[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[6308] trunk/sql12/plugins/oracle/src/main/java/ net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java

[<ger...@us...>]

Revision: 6308
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6308&view=rev
Author:   gerdwagner
Date:     2011-06-25 12:04:50 +0000 (Sat, 25 Jun 2011)

Log Message:
-----------
Performance improvement by sh...@us...

Modified Paths:
--------------
    trunk/sql12/plugins/oracle/src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java

Modified: trunk/sql12/plugins/oracle/src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java
===================================================================
--- trunk/sql12/plugins/oracle/src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java	2011-06-20 19:33:14 UTC (rev 6307)
+++ trunk/sql12/plugins/oracle/src/main/java/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java	2011-06-25 12:04:50 UTC (rev 6308)
@@ -143,8 +143,10 @@
 	/**
 	 * SQL to find schemas to which the logged in user has access
 	 */
-	private static String SCHEMA_ACCESS_SQL = "SELECT DISTINCT OWNER FROM ALL_OBJECTS";
+	//private static String SCHEMA_ACCESS_SQL = "SELECT DISTINCT OWNER FROM ALL_OBJECTS";
+   private static String SCHEMA_ACCESS_SQL = "SELECT owner FROM ALL_OBJECTS group by owner";
 
+
 	/**
 	 * SQL to determine whether or not this account is a DBA account
 	 */


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.