Re: substr() not allowed in Direct Load?

From: <coakleyj_at_hotmail.com>
Date: Mon, 19 Jul 1999 11:01:48 GMT
Message-ID: <7mv0ip$pa4$1@nnrp1.deja.com>

Hi.
Yes, with direct path load, sql functions such as substr, rtrim, ltrim to_char etc etc are not allowed -- Remember that direct path load bypasses the normal "sql" and buffer cache route. In attition, table triggers and constraints are disabled automatically as part of the load (and reenabled afters if you specify so in your control file).

Bye
Coakleyj

In article <379173D4.86ED68A9_at_bigfoot.com>, Doug Cowles <dcowles_at_bigfoot.com> wrote:
> When using SQL*Loade in direct mode, is having substr()
> in the control file illegal?
>
> - Dc.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 19 1999 - 06:01:48 CDT