Question : I have two users A and B. I want to grant B the permission to create, drop, etc. […]
Category: Oracle
Oracle 12c upgrade – backwards compatible with 11g?
Question : Are there any application code changes required for SQL or PL/SQL to continue to work in 12c, or […]
How can I recover a dropped table which is not in the recycle bin?
Question : I dropped a table yesterday and I want to restore it. I know that it’s done with flashback […]
Using Oracle hierarchical queries for transposing field value into rows
Question : One column in my table stores list of values separated by comma (I know it’s a poor design, […]
Duplicating a Database with RMAN
Question : I would like to duplicate to the same server Oracle Database with RMAN. I’ve configured flash recovery area […]
sp2-0667 message file sp2 lang .msb not found and sp2-0750 error is coming on windows
Question : While i am trying to connect with with database by the command sqlplus /nolog than the error message […]
Copy tables of a schema to a new schema using where 1=2
Question : I am trying to spool the below SQL to copy schema objects to another, but its not working. […]
Understanding of schema and tablespaces – recommendation for a later seperation [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
“Table or view does not exist” on synonym
Question : I have a database and a USER administrating it. Then I have an additional USER_APP to whom I […]
ORA-02049 and ORA-02063 Errors
Question : Select For UPDATE NOWAIT is performed on a table by 20 processes in parallel The error below is […]