Find out the history of SQL queries
An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the exact problematic SQL query?
Oracle
How to copy files into a virtual box oracle box
A nice solution could be to share a directory on your host machine with the virtual machine, so you can copy your files in and out. Look at: How to share your computer files with a virtual machine
How can I set a custom date time format in Oracle SQL Developer?
You can change this in preferences: From Oracle SQL Developer’s menu go to: Tools > Preferences. From the Preferences dialog, select Database > NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field. Save and close the dialog, done! Here is a screenshot:
ORA-20002: YOU ARE NOT ALLOWED TO CHANGE THE PASSWORD FOR CRITICAL SCHEMAS
The exception is being raised by a password verification function, assigned to the user via a profile. You can see the profile name and the function being applied by querying: You can then see what the function is actually doing by looking at its source, using the name identified in the previous query: From there … Read more
‘NOT LIKE’ in an SQL query
You have missed out the field name id in the second NOT LIKE. Try: The AND in the where clause joins 2 full condition expressions such as id NOT LIKE ‘1%’ and can’t be used to list multiple values that the id is ‘not like’.
Query to display all tablespaces in a database and datafiles
In oracle, generally speaking, there are number of facts that I will mention in following section: Each database can have many Schema/User (Logical division). Each database can have many tablespaces (Logical division). A schema is the set of objects (tables, indexes, views, etc) that belong to a user. In Oracle, a user can be considered … Read more
Hibernate dialect for Oracle Database 11g?
Use the Oracle 10g dialect. Also Hibernate 3.3.2+ is required for recent JDBC drivers (the internal class structure changed – symptoms will be whining about an abstract class). Dialect of Oracle 11g is same as Oracle 10g (org.hibernate.dialect.Oracle10gDialect). Source: http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/session-configuration.html#configuration-optional-dialects
grant select on view
The error message should be written like this: ORA-01720: “grant option” does not exist for COLLDESK.GESTIONES. Here’s how it works: You have 3 schemas: Schema1 – Holder of a table named “table1” Schema2 – Holder of a view “view1” selecting from schema1.table1 Schema3 – User, selecting from schema2.view1 – has no select granted on schema1.table1. … Read more
How to display databases in Oracle 11g using SQL*Plus
You can think of a MySQL “database” as a schema/user in Oracle. If you have the privileges, you can query the DBA_USERS view to see the list of schemas:
SQL Queries “00904. 00000 – “%s: invalid identifier”
You should try the lower case for the table/column identifiers(like in from/inner join clauses):