Several utilities available to help maintain data in Oracle Database

Q.  Which are the several utilities that are available to help you maintain the data in your Oracle Database?
- Published on 04 Aug 15

a. SQL*Loader
b. Export and Import Utilities
c. Both A & B
d. None of the above

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - Several utilities are available to help you maintain the data in your Oracle Database.

    - The two utilities are:

    1. SQL*Loader - SQL*Loader is used both by database administrators and by other users of Oracle Database.
    - It loads data from standard operating system files (such as, files in text or C data format) into database tables.

    2. Export and Import Utilities - Oracle export and import utilities enable you to move existing data in Oracle format between one Oracle Database and another.
    - For example, export files can archive database data or move data among different databases that run on the same or different operating systems.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)