By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

External Tables

P: n/a
where can i find more information on external tables?

i tried to create one, but get multiple oracle errors starting with
ora-29913
--
berj

Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Berj" <be**@adelphia.net> wrote in message
news:ac********************@adelphia.com...
where can i find more information on external tables?

i tried to create one, but get multiple oracle errors starting with
ora-29913
--
berj

Berj,

The 10g documentation tells that this error message is:
ORA-29913: error in executing <string> callout
Cause: The execution of the specified callout caused an error.
Action: Examine the error messages take appropriate action.

And as such does not allow me to help diagnose the problem.

You could search http://asktom.oracle.com
Daniel Morgan has a FAQ on external tables at
http://www.psoug.org/reference/externaltab.html
There is a simple example at
http://otn.oracle.com/products/oracl...ly/sept19.html
Thomas Kyte has a section on external tables on pp.404 to 415 in Chapter 7:
"Effective Schema Design" of "Effective Oracle by Design" (Oracle
Press:2003).
Conner McDonald et al. has an example of using the alert log as an external
table on pp.371 to 375 in Chapter 7: "DBA Packages" of "Mastering Oracle
PL/SQL: Practical Solutions" (A-Press:2004).

If these references do not help, you might want to post the DDL you are
using as well as the version of Oracle and operating system along with all
the relevant error messages.

Douglas Hawthorne
Jul 19 '05 #2

P: n/a
Start at tahiti.oracle.com, and look at the manuals for your version.

Daniel
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.