Home » SQL & PL/SQL » SQL & PL/SQL » external tables
external tables [message #236294] Wed, 09 May 2007 08:53 Go to next message
priyanka.d
Messages: 20
Registered: May 2007
Junior Member
what are the differences between reject file,bad file,discard file which are mentioned in the scripts of external tables?
Re: external tables [message #236295 is a reply to message #236294] Wed, 09 May 2007 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They are the same ones as for SQL*Loader.
You'll find a description at SQL*Loader Concepts.

Regards
Michel
Re: external tables [message #236299 is a reply to message #236295] Wed, 09 May 2007 09:07 Go to previous messageGo to next message
priyanka.d
Messages: 20
Registered: May 2007
Junior Member
But SQl* Loader and external tables are not the same always.
What for an external table?
Re: external tables [message #236300 is a reply to message #236299] Wed, 09 May 2007 09:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
External table can do more than SQL*Loader as it supports SQL*Loader and Data Pump engines.

And with external tables you can use the power of SQL and PL/SQL engines.

Regards
Michel

[edit: add last sentence]

[Updated on: Wed, 09 May 2007 09:10]

Report message to a moderator

Re: external tables [message #236302 is a reply to message #236300] Wed, 09 May 2007 09:18 Go to previous messageGo to next message
priyanka.d
Messages: 20
Registered: May 2007
Junior Member
but I have found that certain records that donot match necessary criteria donot always go to the bad file or the discard file.
some goes to bad files and some to discard files.
can you tell me the criteria based on which the the files are chosen by these records.
Re: external tables [message #236319 is a reply to message #236302] Wed, 09 May 2007 10:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the link I posted.

Regards
Michel
Re: external tables [message #236335 is a reply to message #236302] Wed, 09 May 2007 11:49 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Utilities Reference: External Tables
Previous Topic: cannot describe table via a dblink
Next Topic: Nth record
Goto Forum:
  


Current Time: Wed Dec 07 14:48:57 CST 2016

Total time taken to generate the page: 0.17958 seconds