Invalid table name while bulk insert in oracle

Question

I am trying to insert values into Oracle table using Bulk Insert query but getting below error

ORA-00903: invalid table name
00903. 00000 -  "invalid table name"
*Cause:    
*Action:
Error at Line: 4 Column: 5

Here is my query

BULK INSERT TEST1.STUDENT
    FROM 'C:\Users\Alan\Desktop\STUDENT.txt'
        WITH
(
            FIELDTERMINATOR = '\t',
            ROWTERMINATOR = '\n'
);

Why is this error coming. Is there some issue with query? Please help. Thanks

Update

I changed by file format to CSV and wrote below query

LOAD DATA
INFILE 'C:\Users\Alan\Desktop\STUDENT.csv'
INTO TABLE TEST1.STUDENT
FIELDS TERMINATED BY ","
(ID,
NAME);

but above query is giving

ORA-00928: missing SELECT keyword
00928. 00000 -  "missing SELECT keyword"
*Cause:    
*Action:
Error at Line: 16 Column: 2

What is wrong in the above syntax?

This is not Oracle syntax at all. – Kacper Dec 13 '16 at 14:41 — Kacper, Dec 13 '16 at 14:41

score 3 · Accepted Answer · edited May 23 '17 at 12:01

This is not Oracle syntax at all. If you need to load data from file to table please use either SQLoader or External table
Some documentation about External table and SQLoader

If you're using SQLDeveloper you can also use import facility.

Please also have a look on that thread.

[EDIT}

LOAD DATA
INFILE 'C:\Users\Alan\Desktop\STUDENT.csv'
INTO TABLE TEST1.STUDENT
FIELDS TERMINATED BY ","
(ID,
NAME);

This is not a query. This is content of control file. Please save it to file load.csv then run cmd (or shell if yuo're on Linux) and type:

sqlldr user/pass control=load.ctl

Some examples you can find here.

Invalid table name while bulk insert in oracle

1 Answers1