Logical backup’s reg & incr exports

17 September, 2018


Related Blogs


  1. logical backup [using export utility] works as an alternative backup method.
  2. The beauty of export is we can be selective [either at export or at import]
  3. We can export from one user and import into another within the same database


  1. We can export from one database and import into another database [both source and target databases are ORACLE datgabases]


  1. When migrating from one platfarm to another from WINDOWS to SUN SOLARIS then export is the only method to transfer the data [at least up on till 9i] since C/R/D files from the source can not be copied over to the target as file system are different types.


  1. When upgrading ORACLE software, as a precaution, we can export of full database before the upgrade. If the upgrade utility able to successfully upgrade software as well as the database then its o.k., but Incase if software upgrading is successful where as data base up gradation has failed then we can still use the exported file which we did before the up gradation, so that we can bring back all the data.
  2. Over a period of time [3 to 4 months] as the data based get fragmentation, being a DBA we used to go for REORG, which includes
    1. Export full database
    2. Drop the existing database
  • Recreate an empty database with all the required table spaces
  1. Import full data

The dump file is 8 to 10 times smaller than database even though we did full export. The reasons are   Screenshot_92  

  1. No base tables are exported into target database.
  2. No control or redo log files rare exported into the target database.
  3. No temp table space is exported
  4. No undo segments since they contain before image.
  5. From user-index only definitions are exported but not the data.
  6. Original data                 10 gbTables are exported with data but they may have 50% free blocks and also 70% pot free

Really used data               2.7 gb [ 10% pot free]Use data                              3 gb [ 50% of occupied] Occupied data                   6 gb   Screenshot_93   ddl + dml [uses undo+ lots of log switches imports takes 6 to 8 times than exports] advantages of exports

  1. works for an alternative backup solutions.
  2. Selective exports or imports are possible
  3. Can copy objects
    1. One user to another user
    2. From one database to another database
    3. From one OS to another OS export files are platform independent.
    4. From one version to another version
  1. Database reorganization [ every 3 to 4 months]
  2. ORACLE up gradation


About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .