sqlldr [message #881] |
Mon, 11 March 2002 00:47 |
jaba
Messages: 3 Registered: March 2002
|
Junior Member |
|
|
Hi,
I'm trying to import formated textfiles into an
oracle table. First everything worked out fine.
Now I want to import the file and simultaniously add a primary key during the import. I have no idea how I'm supposed to do it.
pleeeeeeeeeeeeeeeeease help
jaba
|
|
|
|
Re: sqlldr [message #910 is a reply to message #886] |
Tue, 12 March 2002 04:45 |
jaba
Messages: 3 Registered: March 2002
|
Junior Member |
|
|
hi,
thanx for answering
new problem
first created new table with one more column
second did the import
the column name is nr
i added only one new column and got following error messages
ORA-00604: error occurred at recursive SQL level num
Cause: An error occurred while processing a recursive SQL statement. A recursive SQL statement is one that applies to internal dictionary tables.
Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support.
ORA-00904: invalid column name
Cause: The column name entered is either missing or invalid.
Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, it must be enclosed in double quotation marks. It may not be a reserved word.
|
|
|
Re: sqlldr [message #917 is a reply to message #910] |
Tue, 12 March 2002 19:13 |
jim
Messages: 74 Registered: July 2000
|
Member |
|
|
Looks like the column name you tried to add using the alter table was invalid (name that is) - what was the column name.
|
|
|
Re: sqlldr [message #919 is a reply to message #910] |
Tue, 12 March 2002 21:23 |
jaba
Messages: 3 Registered: March 2002
|
Junior Member |
|
|
nope, i droped the table and created it completely new
drop table test;
create table test (
nr varchar2(5),
bez varchar2(50),
titel varchar2(50),
mgld varchar2(50),
vname varchar2(50),
aname varchar2(100),
str varchar2(100),
nkz varchar2(10),
plz varchar2(10),
ort varchar2(50),
tel varchar2(20),
fax varchar2(20),
grfnr varchar2(10)
)
|
|
|