Day-15 : Logical backups (EXPDP/EXP & IMPDP/IMP)

What is a Logical Backup?
backing up logical objects(tables,indexes,views,schemas,tablespaces,full database) using EXPDP/EXP .

How to take Logical backup?
  click  here for answer


What is the difference between the SQL*Loader and IMPORT utilities?
These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL*Loader utility allows data to be loaded that has been produced by other utilities from different data sources(text files,flat files,excel, CSV files) just so long as it conforms to ASCII formatted or delimited files.

No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...