Добрый человек, вот приложил бы по результатам своей работы сюда инфу, другие люди меньше времени на велосипеды потратили бы.
Пользуйтесь, 6 шагов для загрузки ФИАС:
0. копируем *.dbf в /tmp
1. ставим пакет БД отсюда https://github.com/shredder2003/DBASE_FOX
2. create or replace directory DBF_FILES as '/tmp';
3. 1.
2.
3.
4.
BEGIN
dbase_fox.createExternalTable('ADDROB01.DBF','ADDROB01.DBF,ADDROB02.DBF,ADDROB03.DBF,ADDROB04.DBF,ADDROB05.DBF,ADDROB06.DBF,ADDROB07.DBF,ADDROB08.DBF,ADDROB09.DBF,ADDROB10.DBF,ADDROB11.DBF,ADDROB12.DBF,ADDROB13.DBF,ADDROB14.DBF,ADDROB15.DBF,ADDROB16.DBF,ADDROB17.DBF,ADDROB18.DBF,ADDROB19.DBF,ADDROB20.DBF,ADDROB21.DBF,ADDROB22.DBF,ADDROB23.DBF,ADDROB24.DBF,ADDROB25.DBF,ADDROB26.DBF,ADDROB27.DBF,ADDROB28.DBF,ADDROB29.DBF,ADDROB30.DBF,ADDROB31.DBF,ADDROB32.DBF,ADDROB33.DBF,ADDROB34.DBF,ADDROB35.DBF,ADDROB36.DBF,ADDROB37.DBF,ADDROB38.DBF,ADDROB39.DBF,ADDROB40.DBF,ADDROB41.DBF,ADDROB42.DBF,ADDROB43.DBF,ADDROB44.DBF,ADDROB45.DBF,ADDROB46.DBF,ADDROB47.DBF,ADDROB48.DBF,ADDROB49.DBF,ADDROB50.DBF,ADDROB51.DBF,ADDROB52.DBF,ADDROB53.DBF,ADDROB54.DBF,ADDROB55.DBF,ADDROB56.DBF,ADDROB57.DBF,ADDROB58.DBF,ADDROB59.DBF,ADDROB60.DBF,ADDROB61.DBF,ADDROB62.DBF,ADDROB63.DBF,ADDROB64.DBF,ADDROB65.DBF,ADDROB66.DBF,ADDROB67.DBF,ADDROB68.DBF,ADDROB69.DBF,ADDROB70.DBF,ADDROB71.DBF,ADDROB72.DBF,ADDROB73.DBF,ADDROB74.DBF,ADDROB75.DBF,ADDROB76.DBF,ADDROB77.DBF,ADDROB78.DBF,ADDROB79.DBF,ADDROB83.DBF,ADDROB86.DBF,ADDROB87.DBF,ADDROB89.DBF,ADDROB91.DBF,ADDROB92.DBF,ADDROB99.DBF');
END;
/
4. chmod u+x /tmp/dbf_to_flat_preprocessor.sh
5. 1.
2.
3.
4.
BEGIN
dbase_fox.createExternalTable('ADDROB01.DBF','ADDROB01.DBF,ADDROB02.DBF,ADDROB03.DBF,ADDROB04.DBF,ADDROB05.DBF,ADDROB06.DBF,ADDROB07.DBF,ADDROB08.DBF,ADDROB09.DBF,ADDROB10.DBF,ADDROB11.DBF,ADDROB12.DBF,ADDROB13.DBF,ADDROB14.DBF,ADDROB15.DBF,ADDROB16.DBF,ADDROB17.DBF,ADDROB18.DBF,ADDROB19.DBF,ADDROB20.DBF,ADDROB21.DBF,ADDROB22.DBF,ADDROB23.DBF,ADDROB24.DBF,ADDROB25.DBF,ADDROB26.DBF,ADDROB27.DBF,ADDROB28.DBF,ADDROB29.DBF,ADDROB30.DBF,ADDROB31.DBF,ADDROB32.DBF,ADDROB33.DBF,ADDROB34.DBF,ADDROB35.DBF,ADDROB36.DBF,ADDROB37.DBF,ADDROB38.DBF,ADDROB39.DBF,ADDROB40.DBF,ADDROB41.DBF,ADDROB42.DBF,ADDROB43.DBF,ADDROB44.DBF,ADDROB45.DBF,ADDROB46.DBF,ADDROB47.DBF,ADDROB48.DBF,ADDROB49.DBF,ADDROB50.DBF,ADDROB51.DBF,ADDROB52.DBF,ADDROB53.DBF,ADDROB54.DBF,ADDROB55.DBF,ADDROB56.DBF,ADDROB57.DBF,ADDROB58.DBF,ADDROB59.DBF,ADDROB60.DBF,ADDROB61.DBF,ADDROB62.DBF,ADDROB63.DBF,ADDROB64.DBF,ADDROB65.DBF,ADDROB66.DBF,ADDROB67.DBF,ADDROB68.DBF,ADDROB69.DBF,ADDROB70.DBF,ADDROB71.DBF,ADDROB72.DBF,ADDROB73.DBF,ADDROB74.DBF,ADDROB75.DBF,ADDROB76.DBF,ADDROB77.DBF,ADDROB78.DBF,ADDROB79.DBF,ADDROB83.DBF,ADDROB86.DBF,ADDROB87.DBF,ADDROB89.DBF,ADDROB91.DBF,ADDROB92.DBF,ADDROB99.DBF');
END;
/
6. 1.
2.
3.
4.
select *
from stage_ADDROB01_ext
where CURRSTATUS = 0
;
|
