I recently wanted to drop the indexes during a load and recreate after. There are several ways to do that,… READ MORE
To reduce the amount of space used when exporting one can compress the data as creating export file and also… READ MORE
|
When using datapump one can run the following query to monitor the progress by running the following SQL. select sid,… READ MORE
Last updated: 17-Nov-2008 When exporting/importing one can minimize risk of losing data during import/export by setting NLS_LANG. – Before starting… READ MORE
|
On Oracle9i if you get the following error when running export (exp) utility, to fix this issue one would need… READ MORE
“Control what I can control”
~ Alex Lima