Oracle Database Import

Using power of Oracle Data Pump If you haven’t used oracle Data Pump and still using old IMP / EXP, it’s time for change. It’s very simple to use and at least 10 times faster (my experience) than IMP/EXP. Simple steps to configure 1. CREATE OR REPLACE DIRECTORY EXPIMP AS ‘{path}’; 2. GRANT READ, WRITE […]

Oracle Database Export

Hello,Step by step Oracle database export Schema, Tables, Procedure, Full Database etc. For the examples to work we must first unlock the SYS account and create a directory object it can access. The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file […]