External Tables

[Berj]

where can i find more information on external tables?

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


--
berj

[Douglas Hawthorne]

Re: External Tables

"Berj" <berj@adelphia. netwrote in message
news:ac-dnbgZ1r0ttT7dRV n-gw@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 <stringcallou t
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/oracle9i/daily/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

[Daniel Roy]

Re: External Tables

Start at tahiti.oracle.c om, and look at the manuals for your version.

Daniel