• Oracle

    Oracle Export and Import Backup and Restore-12

    Export and Import Backup and Restore Logical backup: Normal export/import and Data pump Data pump has many features. Like (PARALLEL, Job,NETWORK_LINK,REMAP DATAFILE & tablespace, exclude, include, version, extimate_only) It mostly done in the DB server itself. It access data by direct path and external tables a master process, and worker processes. Whereas normal export/import uses Conventional path. DataPump: Faster, Filtering option (remaps, compression & parallel), job, & self-tuning etc Data Pump Export/Import Normal Export/Import Filtering of data and metadata and remaps etc Not much Change PARTITION_OPTIONS while import No Two process at DB server level Master & Worker It runs on DB & client level Data Pump jobs runs server,…