Upload “Email-Match Export.csv” to the SFTP Server
抚远网站制作公司哪家好，找创新互联公司！从网页设计、网站建设、微信开发、APP开发、响应式网站等网站项目制作，到程序开发，运营维护。创新互联公司从2013年成立到现在10年的时间，我们拥有了丰富的建站经验和运维经验，来保证我们的工作的顺利进行。专注于网站建设就选创新互联公司。
------------create directory
create directory xtern_data_dir_yilin as '/backup/yilin';
------------grant access
GRANT READ, WRITE ON DIRECTORY xtern_data_dir_yilin TO willldb;
Login to Database with WILLLDB
------------create table
SQL> CREATE TABLE survey_respdts_yilin
2 (
3 email_address VARCHAR(200)
4 )
5 ORGANIZATION EXTERNAL
6 (DEFAULT DIRECTORY xtern_data_dir_yilin
7 ACCESS PARAMETERS (
8 RECORDS DELIMITED BY NEWLINE
9 FIELDS TERMINATED BY ".com" LDRTRIM
10 )
11 LOCATION ('Email-Match Export.csv'));
CREATE TABLE survey_respdts_yilin
*
ERROR at line 1:
ORA-25153: Temporary Tablespace is Empty
SQL> create temporary tablespace temp01 tempfile 'd:oracleoradatatestdbtemp01
2 .dbf' size 100m;
Tablespace created.
SQL> alter database default temporary tablespace temp01;
Database altered.
SQL> CREATE TABLE survey_respdts_yilin
2 (
3 email_address VARCHAR(200)
4 )
5 ORGANIZATION EXTERNAL
6 (DEFAULT DIRECTORY xtern_data_dir_yilin
7 ACCESS PARAMETERS (
8 RECORDS DELIMITED BY NEWLINE
9 FIELDS TERMINATED BY ".com" LDRTRIM
10 )
11 LOCATION ('Email-Match Export.csv'));
Table created.