sorry, my poor english
I used the External Tables
firstly, I create the directory and the table
the table ddl like this:
=================================================
create or replace directory bdump
as 'E:\DBData\oradata\ORADIR\bdump';
drop table et_test;
create table et_test (f1 varchar2(100),
f2 varchar2(100),
f3 varchar2(100),
f4 varchar2(100),
f5 varchar2(100),
f6 varchar2(100),
f7 varchar2(100),
f8 varchar2(100),
f9 varchar2(100),
f10 varchar2(100),
f11 varchar2(100),
f12 varchar2(100)
)
organization external (
type oracle_loader
default directory bdump
access parameters (
records delimited by newline
nobadfile
nodiscardfile
nologfile
fields terminated by ','
optionally enclosed by '"'
)
location('et_test.txt')
)
reject limit unlimited
/
=================================================
then, the data file et_test.txt like this(1,000,000 records)
"0031","0031","136200","test"," "," "," "," "," ","0000091912"," "," "
"0031","0031","136200","test"," ","3613998"," "," "," ","0000091913"," ","3613998"
"0031","0031"," ","test"," ","6225056"," "," "," ","0000091914"," ","6225056"
"0031","0031"," ","test"," ","6226228"," "," "," ","0000091915"," ","6226228"
"0031","0031","136200","test"," "," "," "," "," ","0000091916"," "," "
"0031","0031","136200","test"," ","3234095"," "," "," ","0000091917"," ","3234095"
"0031","0031","136200","test"," ","3225659"," "," "," ","0000091918"," ","3225659"
"0031","0031"," ","test"," ","6226245"," "," "," ","0000091919"," ","6226245"
"0031","0031","136200","test"," ","3224216"," "," "," ","0000091920"," ","3224216"
"0031","0031","136200","test"," ","3611022"," "," "," ","0000091921"," ","3611022"
"0031","0031","136200","test"," "," "," "," "," ","0000091922"," "," "
"0031","0031","136200","test"," ","3227588"," "," "," ","0000091923"," ","3227588"
"0031","0031","136200","test"," "," "," "," "," ","0000091924"," "," "
"0031","0031","136200","test"," "," "," "," "," ","0000091925"," "," "
"0031","0031","136200","test"," ","3229918"," "," "," ","0000091926"," ","3229918"
"0031","0031","136200","test"," "," "," "," "," ","0000091927"," "," "
"0031","0031","136200","test"," ","3220383"," "," "," ","0000091928"," ","3220383"
"0031","0031","136200","test"," "," "," "," "," ","0000091929"," "," "
"0031","0031"," ","test"," ","6229767"," "," "," ","0000091930"," ","6229767"
......
then, I query the data with the sql statement:
select * from et_test;
a error occured with this infomation:
"found record longer than buffer size supported,65506,in
E:\DBData\oradata\ORADIR\bdump\et_test.txt"
what can I do with the buffer size
how can I get all the records for the data file?
|
] 
Blog
Search
Help
Members
Register
Login
Home
