Creating an external is not a easy task. Why? Because, at least for me, this is one of the most complexes Oracle syntaxes.
So, the best approach for me in this topic is to go quickly in the documentation place of external tables and use a template.
Practice a bit to be prepared for the exam:
- Create a SQL Loader external table
- Test using some preprocessor script
- Load a Data Pump file using external table
- Create a Data Pump external table
Path to Documentation:
Administrator's Guide -> Managing External Tables
Utilities -> Part III External Tables
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
