Mark Forums Read

sqlldr: setting NULL instead of rejecting record

Go Back

comp.databases.oracle.tools comp.databases.oracle.tools

Reply

#1

Old

Mathias Waack

Posts: n/a

sqlldr: setting NULL instead of rejecting record - 02-03-2008 , 02:42 AM

Hi all,

I'm going to import a table into oracle by using sqlldr. The table contains
some cells with wrong contents, for instance number fields with text or date
fields with invalid dates. sqlldr rejects these records. Is there an option
the tell sqlldr to just set wrong values to NULL intead of rejecting the
whole record?

Thanks,

Mathias

Reply With Quote

#2

Old

fitzjarrell@cox.net

Posts: n/a

Re: sqlldr: setting NULL instead of rejecting record - 02-04-2008 , 08:11 AM

On Feb 3, 2:42*am, Mathias Waack <M.Wa... (AT) gmx (DOT) de> wrote:

Quote:

Hi all,

I'm going to import a table into oracle by using sqlldr. The table contains
some cells with wrong contents, for instance number fields with text or date
fields with invalid dates. sqlldr rejects these records. Is there an option
the tell sqlldr to just set wrong values to NULL intead of rejecting the
whole record?

Thanks,

* * * * Mathias

There is (NULLIF) but it won't work in your case as you can't
guarantee the exact same value will appear in a given column across
multiple records.

I'd seriously suggest you fix the data, rather than try to finagle
SQL*Loader into replacing the errant values with NULLs.

David Fitzjarrell

Reply With Quote

#3

Old

fitzjarrell@cox.net

Posts: n/a

Re: sqlldr: setting NULL instead of rejecting record - 02-04-2008 , 08:11 AM

On Feb 3, 2:42*am, Mathias Waack <M.Wa... (AT) gmx (DOT) de> wrote:

Quote:

Hi all,

I'm going to import a table into oracle by using sqlldr. The table contains
some cells with wrong contents, for instance number fields with text or date
fields with invalid dates. sqlldr rejects these records. Is there an option
the tell sqlldr to just set wrong values to NULL intead of rejecting the
whole record?

Thanks,

* * * * Mathias

There is (NULLIF) but it won't work in your case as you can't
guarantee the exact same value will appear in a given column across
multiple records.

I'd seriously suggest you fix the data, rather than try to finagle
SQL*Loader into replacing the errant values with NULLs.

David Fitzjarrell

Reply With Quote

#4

Old

fitzjarrell@cox.net

Posts: n/a

Re: sqlldr: setting NULL instead of rejecting record - 02-04-2008 , 08:11 AM

On Feb 3, 2:42*am, Mathias Waack <M.Wa... (AT) gmx (DOT) de> wrote:

Quote:

Hi all,

I'm going to import a table into oracle by using sqlldr. The table contains
some cells with wrong contents, for instance number fields with text or date
fields with invalid dates. sqlldr rejects these records. Is there an option
the tell sqlldr to just set wrong values to NULL intead of rejecting the
whole record?

Thanks,

* * * * Mathias

There is (NULLIF) but it won't work in your case as you can't
guarantee the exact same value will appear in a given column across
multiple records.

I'd seriously suggest you fix the data, rather than try to finagle
SQL*Loader into replacing the errant values with NULLs.

David Fitzjarrell

Reply With Quote

#5

Old

fitzjarrell@cox.net

Posts: n/a

Re: sqlldr: setting NULL instead of rejecting record - 02-04-2008 , 08:11 AM

On Feb 3, 2:42*am, Mathias Waack <M.Wa... (AT) gmx (DOT) de> wrote:

Quote:

Hi all,

I'm going to import a table into oracle by using sqlldr. The table contains
some cells with wrong contents, for instance number fields with text or date
fields with invalid dates. sqlldr rejects these records. Is there an option
the tell sqlldr to just set wrong values to NULL intead of rejecting the
whole record?

Thanks,

* * * * Mathias

There is (NULLIF) but it won't work in your case as you can't
guarantee the exact same value will appear in a given column across
multiple records.

I'd seriously suggest you fix the data, rather than try to finagle
SQL*Loader into replacing the errant values with NULLs.

David Fitzjarrell

Reply With Quote

#6

Old

fitzjarrell@cox.net

Posts: n/a

Re: sqlldr: setting NULL instead of rejecting record - 02-04-2008 , 08:11 AM

On Feb 3, 2:42*am, Mathias Waack <M.Wa... (AT) gmx (DOT) de> wrote:

Quote:

Hi all,

I'm going to import a table into oracle by using sqlldr. The table contains
some cells with wrong contents, for instance number fields with text or date
fields with invalid dates. sqlldr rejects these records. Is there an option
the tell sqlldr to just set wrong values to NULL intead of rejecting the
whole record?

Thanks,

* * * * Mathias

There is (NULLIF) but it won't work in your case as you can't
guarantee the exact same value will appear in a given column across
multiple records.

I'd seriously suggest you fix the data, rather than try to finagle
SQL*Loader into replacing the errant values with NULLs.

David Fitzjarrell

Reply With Quote

#7

Old

fitzjarrell@cox.net

Posts: n/a

Re: sqlldr: setting NULL instead of rejecting record - 02-04-2008 , 08:11 AM

On Feb 3, 2:42*am, Mathias Waack <M.Wa... (AT) gmx (DOT) de> wrote:

Quote:

Hi all,

I'm going to import a table into oracle by using sqlldr. The table contains
some cells with wrong contents, for instance number fields with text or date
fields with invalid dates. sqlldr rejects these records. Is there an option
the tell sqlldr to just set wrong values to NULL intead of rejecting the
whole record?

Thanks,

* * * * Mathias

There is (NULLIF) but it won't work in your case as you can't
guarantee the exact same value will appear in a given column across
multiple records.

I'd seriously suggest you fix the data, rather than try to finagle
SQL*Loader into replacing the errant values with NULLs.

David Fitzjarrell

Reply With Quote

#8

Old

fitzjarrell@cox.net

Posts: n/a

Re: sqlldr: setting NULL instead of rejecting record - 02-04-2008 , 08:11 AM

On Feb 3, 2:42*am, Mathias Waack <M.Wa... (AT) gmx (DOT) de> wrote:

Quote:

Hi all,

I'm going to import a table into oracle by using sqlldr. The table contains
some cells with wrong contents, for instance number fields with text or date
fields with invalid dates. sqlldr rejects these records. Is there an option
the tell sqlldr to just set wrong values to NULL intead of rejecting the
whole record?

Thanks,

* * * * Mathias

There is (NULLIF) but it won't work in your case as you can't
guarantee the exact same value will appear in a given column across
multiple records.

I'd seriously suggest you fix the data, rather than try to finagle
SQL*Loader into replacing the errant values with NULLs.

David Fitzjarrell

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.