----------创建目录---------
create or replace directory EXT_DATA_DIR_QLJ as '/data/ext_data/xueyuan/QLJ';
----------授权-------------
grant read,write on directory EXT_DATA_DIR_QLJ to vp_dm_qlj;
-----------查询用户--------
select * FROM DBA_DIRECTORIES;
----------创建外表----------
ETL程序从数据接口文件加载数据到外表
最新推荐文章于 2024-04-23 13:27:47 发布