-
Taking Manual backup with RMAN
You have taken a manual backup of a datafile using o/s. How RMAN will know about it?
-
How to get max value from different columns of a table ?
Suppose Input table is COL1 COL2 COL 3A 1 -3B -2 6c 3 -4D 9 10In sql query I want the desired output as follows COL1 COL nA 1B 6C 3D 10Please write the query to get this output
-
Private,Public database link
How to give private and public database links ?What is syntax for that ?What means mutation in oracle??
-
SQL
What are the data types in oracle?
-
Index Use
If you have a three columns table with one index on 2nd Column. In the SELECT statement you retrived column 1, can index be used or not?
-
Repair TNSnames.ora File
How to repair the tnsnames.ora file. File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine.
-
Identify target database
How do you identify what are the all the target databases that are being backed-up with RMAN database?
-
-