I’m using Oracle for development. The password for a bootstrap account that I always use to rebuild my database has expired. How do I turn off password expiration for this user (and all other users) permanently? I’m using Oracle 11g, which has passwords expire by default. 6 Answers 6
I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then I got the following error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) … Read more
What are the maximum length of a table name and column name in Oracle? 12 Answers 12
By default, Oracle SQL developer displays date values as 15-NOV-11. I would like to see the time part (hour/minute/second) by default. Is there a way to configure this within Oracle SQL Developer? 9 Answers 9
Why am I getting this database error when I update a table? ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 15 Answers 15
I’ve heard people referring to this table and was not sure what it was about. 14 Answers 14
I’m using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn’t give me any export options. 6 Answers 6
In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can add, delete, edit or just viewing records of table currently viewd the problem is that we often really need to view more than one table at once, then we need more than … Read more
We have an application running locally where we’re experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I’ve tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try connecting, which failed with the same error as above. I used this syntax for SQLPlus: sqlplus … Read more
What is the difference between varchar and varchar2? 6 Answers 6
