Topic: SQL*Plus and PL/SQL >> ControlFiles
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| chinna |
Posted: Oct 25, 2007 02:28:37 AM |
Total Post: 28
Joined: May, 2007
|
hi,
I am loading data from control files to some temporary tables by means of sql loader ,
records are inserting into temporary tables which are valid and some records are going into bad files which are not valid.
so my question is to load that data into some x tables from bad files ,
so that i can easily track that particular record from that x table since my source file contains some lakhs of records it's a cumbersome.
ex:
LOAD DATA
INFILE 'Student1\Student.dat'
BADFILE 'Student1\Student.bad'
DISCARDFILE 'Student1\Student.dsc'
TRUNCATE
INTO TABLE student
FIELDS TERMINATED BY "," optionally enclosed by '"'
(Name,Number,Address1,City,State)
I want to retreive the bad files data to some temporary tables.
Expecting Reply......
Thanks
Chinna |
|
|
 Ramesh Joyisa |
| Posted: Oct 25, 2007 07:42:00 AM |  |
|
Total Post: 246
Joined: Aug, 2007
|
I think this is not possible because the BAD file is a text file filled with improperly formatted data. For example, if a record in the text file has too few columns or a character where a number was expected, that record won't be loaded into the database and will instead be put into the BAD file, if specified with the BAD parameter. When there is no perticular format available then what structure you will keep for the table to insert it?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
