• 1.

    I'm sorry but I have to strongly disagree, not just me... the whole Oracle community

    I wonder why to disagree when Oracle itself is defining logical backup as a valid backup method.

    Oracle® Database Backup and Recovery Basics

    Logical backups contain logical data (for example, tables or stored procedures) exported from a database with an Oracle export utility and stored in a binary file, for later re-importing into a database using the corresponding Oracle import utility.

    And from the Oracle community:

    What is import/export and why does one need it?

    Oracle's export (exp) and import (imp) utilities are used to perform logical database backup and recovery. When exporting, database objects are dumped to a binary file which can then be imported into another Oracle database.

    2.

    You cannot equate BCP to exp/imp. One quick reason is exp/imp is to move data between Oracle databases while BCP is an ETL tool. The counterpart of BCP in the Oracle is the good ol' SQL*loader. This is the primitive tool that Oracle has got while SQL Server has far more sophisticated DTS and SSIS which can be programmed to do a lot of ETL automations.

    3.

    Thanks for your valuable info on Oracle backup 🙂

    -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]