Can I redirect output of an external table to an internal table?

Can I redirect the output of the bad file and log file of an external table into another internal table in Oracle 10g? Also, can I create a function object on an external table?

    Requires Free Membership to View

    Login

The bad file and the log file, when referencing external tables, must reside on the OS filesystem. You cannot store this information in another database table.

You can create a user-defined function that references an external table in its PL/SQL block of code. Keep in mind that if you drop or redesign the external table, it will invalidate this function, just as it would with regular tables.

This was first published in January 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top