CHAPTER 14
External Tables
Sometimes, DBAs and developers don’t grasp the utility of external tables. The Oracle external table feature enables you to perform two distinct operations:
- Transparently select information from OS comma-separated-value (CSV) files via SQL, which allows you to do tasks such as loading these files into the database.
- Create platform-independent dump files that can be used to transfer data. You can also create these files as compressed and encrypt them for efficient and secure data transportation.
Tip CSV files are ...
Get Pro Oracle Database 12c Administration, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
