Ask the Expert

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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: