| creation of external table [message #635374] |
Sat, 28 March 2015 08:43  |
 |
dmitry1986
Messages: 4
Registered: March 2015
Location: Torornto
|
Junior Member |
|
|
I want to crate external table based on datafile, but I got error. I use whitespace to delimit my record but this doesn work . Yes I created directory and gave read and write permissions than I created my external table . However when I selected it I got an error. ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error
my external table is :
create table nflteams_ext (
ACR varchar2(4),
NAME varchar2(20))
organization external
(
type oracle_loader
default directory ext_tab_data
access parameters (
records delimited by newline CHARACTERSET US7ASCII
fields terminated by whitespace
missing field values are null
(ACR varchar2(4),
NAME varchar2(20))
)
LOCATION ('NFL_Teams.dat')
)
REJECT LIMIT UNLIMITED NOPARALLEL;
data file:
NO New Orleans Saints
PIT Pittsburgh Steelers
IND Indianapolis Colts
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
