Re: Secure File Privilege
With your table on a Windows machine where secure_file_prov="c:/in", this Load Data cmd works ...
LOAD DATA INFILE 'c:/in/aisle.csv'
INTO TABLE aisle
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';
select * from aisle;
+---------+------------------+
| idaisle | aisleDescription |
+---------+------------------+
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| 6 | 6 |
| 7 | 7 |
| 8 | 8 |
| 9 | 9 |
+---------+------------------+
Subject
Views
Written By
Posted
1096
February 22, 2022 12:17PM
575
February 22, 2022 12:39PM
557
February 22, 2022 01:00PM
531
February 22, 2022 01:03PM
518
February 22, 2022 01:41PM
782
February 22, 2022 03:16PM
495
February 22, 2022 05:09PM
646
February 26, 2022 03:34AM
692
August 18, 2022 12:34PM
435
August 18, 2022 10:47PM
454
August 19, 2022 10:22AM
Re: Secure File Privilege
456
August 19, 2022 11:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.