-
Search Method
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?
-
Resize Tablespaces
Is it possible to resize tablespaces and data files? If yes, how?
-
Import Export Utilities
How does one use the import/export utilities?
-
Physical Standby Database
Outline the steps required for physical standby database creation?
-
Export query question
exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y buffer=1000000If i do't mention compress & buffer parameter , then this query will run/not.