---------------------------------------------------------------------------------------------------- * Why can I not see any tables? If you login as a user other than the table owner, scroll down to "Other Users". ---------------------------------------------------------------------------------------------------- * How do I reset my password if it has expired? The SQL Developer based on JDBC thin client (which is the most common one) cannot do this. You have to use a tool based on OCI including SQL*Plus to do it. If this is a frequent issue in your company, consider creating a password self-service website. See ./PasswordSelfService.txt on this web site. ---------------------------------------------------------------------------------------------------- * Why does some code work in SQL Developer but does not work when copied to SQL*Plus? Maybe there're blank lines in straight SQL (not PL/SQL)? Even though SQL Developer appears to set SQLBLANKLINES to off, it behaves as if it was on. But in SQL*Plus, you really have to set it to on, or you have to remove blank lines. There are other minor differences between these two tools. ---------------------------------------------------------------------------------------------------- * How do I set up to use LDAP to resolve a connection? Connection Type: LDAP Role: default LDAP Server: : Context: Click Load, which populates the DB Service drop-down. Choose the connect identifier you want to use in the DB Service drop-down. ---------------------------------------------------------------------------------------------------- * How can I refresh an LDAP-based connection after the hostname and/or service name in Oracle LDAP (OID) has changed? The cache cannot be refreshed. Before Oracle eventually adds the no cache option (Bug 35714622), the only supported solution is to delete and re-create the connection, which requires you enter the password. You may try the unsupported solution, especially when you don't remember the password and don't want it to be reset. The cache file is C:\Users\\AppData\Roaming\SQL Developer\system\o.jdeveloper.db.connection\connections.json Just edit it and try connecting again. ----------------------------------------------------------------------------------------------------