十年网站开发经验 + 多家企业客户 + 靠谱的建站团队
量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决
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.