使用ora2pg遷移oracle數(shù)據(jù)到greenplum

安裝ora2pg條件
1、perl版本5.10以上
2瘟芝、安裝DBD::Oracle
3易桃、安裝DBI
4、安裝DBD::Pg

一锌俱、安裝相關(guān)軟件支持

1晤郑、安裝DBI
#下載
https://metacpan.org/release/DBI
上傳到服務(wù)器并解壓出來DBI-1.637.tar.gz 
[ root@bigdata01 ~]$ ll
total 592
-rw-r--r-- 1 gpadmin gpadmin 596423 Dec  4 15:05 DBI-1.637.tar.gz
drwxr-xr-x 2 gpadmin gpadmin   4096 Dec  1 16:12 gpAdminLogs
drwxr-xr-x 2 gpadmin gpadmin   4096 Dec  1 16:11 gpconfigs
[gpadmin@bigdata01 ~]$ tar -zxvf DBI-1.637.tar.gz 
DBI-1.637/
DBI-1.637/Changes
DBI-1.637/dbd_xsh.h
DBI-1.637/DBI.pm
DBI-1.637/DBI.xs
DBI-1.637/dbi_sql.h
DBI-1.637/dbilogstrip.PL
[root@bigdata01 ~]$
[root@bigdata01 ~]$ ll
total 596
drwxr-x--- 5 gpadmin gpadmin   4096 Aug 16 16:45 DBI-1.637
-rw-r--r-- 1 gpadmin gpadmin 596423 Dec  4 15:05 DBI-1.637.tar.gz
drwxr-xr-x 2 gpadmin gpadmin   4096 Dec  1 16:12 gpAdminLogs
drwxr-xr-x 2 gpadmin gpadmin   4096 Dec  1 16:11 gpconfigs
[root@bigdata01 ~]$ cd DBI-1.637
[root@bigdata01 DBI-1.637]$ perl Makefile.PL

*** Your LANG environment variable is set to 'en_US.UTF-8'
*** This may cause problems for some perl installations.
*** If you get test failures, please try again with LANG unset.
*** If that then works, please email dbi-dev@perl.org with details
*** including the output of 'perl -V'
…………
[root@bigdata01 DBI-1.637]$ 
[root@bigdata01 DBI-1.637]$ make
/usr/bin/perl -MExtUtils::Command -e 'mkpath' -- blib/lib/DBI
rm -f blib/lib/DBI/Changes.pm
cp Changes blib/lib/DBI/Changes.pm
cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h
cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm
cp lib/DBI/Gofer/Response.pm blib/lib/DBI/Gofer/Response.pm
cp lib/DBI/Util/_accessor.pm blib/lib/DBI/Util/_accessor.pm
cp lib/DBI/Gofer/Transport/Base.pm blib/lib/DBI/Gofer/Transport/Base.pm
cp lib/DBD/DBM.pm blib/lib/DBD/DBM.pm
cp DBIXS.h blib/arch/auto/DBI/DBIXS.h
cp dbixs_rev.pl blib/lib/dbixs_rev.pl
cp lib/DBI/Gofer/Serializer/DataDumper.pm blib/lib/DBI/Gofer/Serializer/DataDumper.pm
cp lib/DBI/Const/GetInfoType.pm blib/lib/DBI/Const/GetInfoType.pm
cp lib/DBI/DBD/Metadata.pm blib/lib/DBI/DBD/Metadata.pm
…………
[root@bigdata01 DBI-1.637]$
[root@bigdata01 DBI-1.637]$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01basics.t .................... # --- Perl 5.010001 on x86_64-linux-thread-multi
t/01basics.t .................... ok       
t/02dbidrv.t .................... ok     
t/03handle.t .................... ok       
t/04mods.t ...................... ok     
t/05concathash.t ................ ok     
t/06attrs.t ..................... ok 
…………
[root@bigdata01 DBI-1.637]# 
[root@bigdata01 DBI-1.637]# make install
Manifying blib/man1/dbiproxy.1
Manifying blib/man1/dbilogstrip.1
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib64/perl5/auto/DBI/DBIXS.h
Installing /usr/local/lib64/perl5/auto/DBI/dbixs_rev.h
…………

2、安裝DBD::Oracle
#下載
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
上傳到服務(wù)器并安裝
oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-jdbc-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
[root@bigdata01 ~]# ll
total 54480
drwxr-xr-x 5 sa_cluster sa_group     4096 Dec  6 15:46 DBD-Pg-1.32
-rw-r--r-- 1 root       root        96233 Dec  4 15:21 DBD-Pg-1.32.tar.gz
drwxr-x--- 6 ogg        games        4096 Dec  6 15:40 DBI-1.637
drwxr-xr-x 2 root       root         4096 Dec  1 15:47 gpAdminLogs
-rw-r--r-- 1 root       root     52826628 Dec  4 16:16 oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
-rw-r--r-- 1 root       root       606864 Dec  4 16:14 oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
-rw-r--r-- 1 root       root      1524160 Dec  4 16:28 oracle-instantclient12.2-jdbc-12.2.0.1.0-1.x86_64.rpm
-rw-r--r-- 1 root       root       708104 Dec  4 16:28 oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
[root@bigdata01 ~]# 
[root@bigdata01 ~]# rpm -ivh oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
Preparing...                ########################################### [100%]
   1:oracle-instantclient12.########################################### [100%]
[root@bigdata01 ~]# rpm -ivh oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
Preparing...                ########################################### [100%]
   1:oracle-instantclient12.########################################### [100%]
[root@bigdata01 ~]# rpm -ivh oracle-instantclient12.2-jdbc-12.2.0.1.0-1.x86_64.rpm
Preparing...                ########################################### [100%]
   1:oracle-instantclient12.########################################### [100%]
[root@bigdata01 ~]# rpm -ivh oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
Preparing...                ########################################### [100%]
   1:oracle-instantclient12.########################################### [100%]
[root@bigdata01 ~]# 
#下載
http://search.cpan.org/~pythian/DBD-Oracle-1.74/lib/DBD/Oracle.pm
上傳到服務(wù)器并解壓出來DBD-Oracle-1.74.tar.gz
[root@bigdata01 ~]# tar -zxvf DBD-Oracle-1.74.tar.gz 
DBD-Oracle-1.74/
DBD-Oracle-1.74/lib/
DBD-Oracle-1.74/lib/DBD/
DBD-Oracle-1.74/lib/DBD/Oracle.pm
DBD-Oracle-1.74/lib/DBD/Oracle/
…………
[root@bigdata01 DBD-Oracle-1.74]# 
[root@bigdata01 ~]# cd DBD-Oracle-1.74
[root@bigdata01 DBD-Oracle-1.74]#  export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib
[root@bigdata01 DBD-Oracle-1.74]# export ORACLE_HOME=/usr/lib/oracle/12.2/client64/lib
[root@bigdata01 DBD-Oracle-1.74]# perl Makefile.PL  -V 12.2
Using DBI 1.637 (for perl 5.010001 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/

Configuring DBD::Oracle for perl 5.010001 on linux (x86_64-linux-thread-multi)

Remember to actually *READ* the README file! Especially if you have any problems.
…………
[root@bigdata01 DBD-Oracle-1.74]# make
cp lib/DBD/Oracle/Troubleshooting/Cygwin.pod blib/lib/DBD/Oracle/Troubleshooting/Cygwin.pod
cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/Troubleshooting/Hpux.pod blib/lib/DBD/Oracle/Troubleshooting/Hpux.pod
cp lib/DBD/Oracle/Troubleshooting/Vms.pod blib/lib/DBD/Oracle/Troubleshooting/Vms.pod
…………
[root@bigdata01 DBD-Oracle-1.74]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/000-report-versions-tiny.t .. # 
# 
# Generated by Dist::Zilla::Plugin::ReportVersions::Tiny v1.10
# perl: 5.010001 (wanted 5.006) on linux from /usr/bin/perl
# 
# B                                             => 1.22       (want any version)
# Carp                                          => 1.11       (want any version)
# DBI                                           => 1.637      (want 1.51)   
# Data::Dumper                                  => 2.124      (want any version)
# Devel::Peek                                   => 1.04       (want any version)
…………
[root@bigdata01 DBD-Oracle-1.74]# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib64/perl5/auto/DBD/Oracle/mk.pm
Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.h
Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so
Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.bs
Installing /usr/local/lib64/perl5/auto/DBD/Oracle/ocitrace.h
Installing /usr/local/lib64/perl5/auto/DBD/Oracle/dbdimp.h
Installing /usr/local/lib64/perl5/DBD/Oracle.pm
…………

3贸宏、安裝DBD::Pg
#下載
http://search.cpan.org/~rudy/DBD-Pg/Pg.pm
上傳到服務(wù)器并解壓出來DBD-Pg-1.32.tar.gz
[root@bigdata01 ~]# ll
total 104
-rw-r--r-- 1 root root  96233 Dec  4 15:21 DBD-Pg-1.32.tar.gz
drwxr-x--- 6 ogg  games  4096 Dec  6 15:40 DBI-1.637
drwxr-xr-x 2 root root   4096 Dec  1 15:47 gpAdminLogs
[root@bigdata01 ~]# tar -zxvf DBD-Pg-1.32.tar.gz 
DBD-Pg-1.32/
DBD-Pg-1.32/t/
DBD-Pg-1.32/t/02attribs.t
DBD-Pg-1.32/t/99_pod.t
DBD-Pg-1.32/t/01setup.t
DBD-Pg-1.32/t/01constants.t
DBD-Pg-1.32/t/12placeholders.t
…………
[root@bigdata01 ~]#
[root@bigdata01 ~]# cd DBD-Pg-1.32
[root@bigdata01 DBD-Pg-1.32]# perl Makefile.PL
Configuring Pg
Remember to actually read the README file!
Path to pg_config? 
OS: linux
PostgreSQL version: ..

****************
WARNING! DBD::Pg no longer supports versions less than 7.2.
It is highly recommended that you upgrade PostgreSQL to a newer version.
****************

Using DBI 1.637 (for perl 5.010001 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/
Checking if your kit is complete...
Looks good
Using DBI 1.637 (for perl 5.010001 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/
Writing Makefile for DBD::Pg
[root@bigdata01 DBD-Pg-1.32]# 
[root@bigdata01 DBD-Pg-1.32]# make
Skip blib/lib/DBD/Pg.pm (unchanged)
gcc -c  -I/opt/greenplum-db-4.3.17.1/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DHAVE_PQescapeString -DHAVE_PQescapeBytea -DHAVE_PQunescapeBytea -DHAVE_PQfreemem -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"1.32\" -DXS_VERSION=\"1.32\" -fPIC "-I/usr/lib64/perl5/CORE"   Pg.c
[root@bigdata01 DBD-Pg-1.32]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00basic.t ......... ok   
t/01connect.t ....... Use of uninitialized value $DBD::Pg::VERSION in concatenation (.) or string at t/01connect.t line 64.
Use of uninitialized value $pgversion in concatenation (.) or string at t/01connect.t line 64.
[root@bigdata01 DBD-Pg-1.32]# make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib64/perl5/auto/DBD/Pg/Pg.bs
Installing /usr/local/lib64/perl5/auto/DBD/Pg/Pg.so
Installing /usr/local/lib64/perl5/DBD/Pg.pm
Installing /usr/local/share/man/man3/DBD::Pg.3pm
Appending installation info to /usr/lib64/perl5/perllocal.pod
[root@bigdata01 DBD-Pg-1.32]#

二造寝、安裝ora2pg

#下載
https://github.com/darold/ora2pg/releases
ora2pg-18.2.tar.gz
[root@bigdata01 ~]# tar -zxvf ora2pg-18.2.tar.gz
ora2pg-18.2/
ora2pg-18.2/INSTALL
ora2pg-18.2/LICENSE
ora2pg-18.2/MANIFEST
ora2pg-18.2/Makefile.PL
…………
[root@bigdata01 ~]# cd ora2pg-18.2/
[root@bigdata01 ora2pg-18.2]# perl Makefile.PL
Checking if your kit is complete...
Looks good
Writing Makefile for Ora2Pg

Done...
------------------------------------------------------------------------------
Please read documentation at http://ora2pg.darold.net/ before asking for help
------------------------------------------------------------------------------
Now type: make && make install
[root@bigdata01 ora2pg-18.2]# 
[root@bigdata01 ora2pg-18.2]# make && make install
cp lib/Ora2Pg.pm blib/lib/Ora2Pg.pm
cp lib/Ora2Pg/GEOM.pm blib/lib/Ora2Pg/GEOM.pm
cp lib/Ora2Pg/PLSQL.pm blib/lib/Ora2Pg/PLSQL.pm
cp lib/Ora2Pg/MySQL.pm blib/lib/Ora2Pg/MySQL.pm
cp scripts/ora2pg blib/script/ora2pg
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ora2pg
cp scripts/ora2pg_scanner blib/script/ora2pg_scanner
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ora2pg_scanner
Manifying blib/man3/ora2pg.3
Installing /usr/local/share/perl5/Ora2Pg.pm
Installing /usr/local/share/perl5/Ora2Pg/GEOM.pm
Installing /usr/local/share/perl5/Ora2Pg/MySQL.pm
Installing /usr/local/share/perl5/Ora2Pg/PLSQL.pm
Installing /usr/local/share/man/man3/ora2pg.3
Installing /usr/local/bin/ora2pg_scanner
Installing /usr/local/bin/ora2pg
Installing default configuration file (ora2pg.conf.dist) to /etc/ora2pg
Appending installation info to /usr/lib64/perl5/perllocal.pod
[root@bigdata01 ora2pg-18.2]# 

#檢查所有軟件是否安裝成功
[root@bigdata01 ora2pg-18.2]# vi list.pl
[root@bigdata01 ora2pg-18.2]# cat list.pl 
#!/usr/bin/perl
use strict;
use ExtUtils::Installed;
my $inst= ExtUtils::Installed->new();
my @modules = $inst->modules();
foreach(@modules)
{
        my $ver = $inst->version($_) || "???";
        printf("%-12s --  %s\n", $_, $ver);  
}
exit;
[root@bigdata01 ora2pg-18.2]# 
[root@bigdata01 ora2pg-18.2]# perl list.pl
DBD::Oracle  --  1.74
DBD::Pg      --  1.32
DBI          --  1.637
Ora2Pg       --  18.2
Perl         --  5.10.1
[root@bigdata01 ora2pg-18.2]#

三、配置

[root@bigdata01 ora2pg]# vi /etc/ora2pg/ora2pg.conf.dist 
ORACLE_HOME     /usr/lib/oracle/12.2/client64/lib
ORACLE_DSN      dbi:Oracle:host=xxx.xxx.xxx.xxx;sid=orcl;port=1521
ORACLE_USER     xxx
ORACLE_PWD      xxx
SCHEMA         數(shù)據(jù)庫名
NLS_LANG        AMERICAN_AMERICA.AL32UTF8
TYPE            TABLE   DATA
OUTPUT  output.sql


[root@bigdata01 ora2pg]# ora2pg -c ora2pg.conf.dist 
Can't locate Time/HiRes.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /usr/local/share/perl5/Ora2Pg.pm line 33.
BEGIN failed--compilation aborted at /usr/local/share/perl5/Ora2Pg.pm line 33.
Compilation failed in require at /usr/local/bin/ora2pg line 30.
BEGIN failed--compilation aborted at /usr/local/bin/ora2pg line 30.
[root@bigdata01 ora2pg]#
報這個錯是perl沒有完全安裝導(dǎo)致
下載相應(yīng)版本并上傳到服務(wù)器http://www.cpan.org/src/5.0/
perl-5.10.1.tar.gz
[root@bigdata01 ~]#tar -zxvf perl-5.10.1.tar.gz
[root@bigdata01 ~]#cd perl-5.10.1
[root@bigdata01 perl-5.10.1]#
[root@bigdata01 perl-5.10.1]# ./Configure -d -Dusethreads
[root@bigdata01 perl-5.10.1]# make
[root@bigdata01 perl-5.10.1]# make test
[root@bigdata01 perl-5.10.1]# make install

四吭练、導(dǎo)出oracle數(shù)據(jù)

#進入/etc/ora2pg目錄下
[ogg@bigdata01 ora2pg]$ pwd
/etc/ora2pg
#編輯配置文件
ORACLE_HOME     /usr/lib/oracle/12.2/client64/lib
# Set Oracle database connection (datasource, user, password)
ORACLE_DSN      dbi:Oracle:host=xx.xx.xx.xx;sid=xxxx;port=1521
ORACLE_USER     xxxxxx    
ORACLE_PWD      xxxxxx
SCHEMA          xxxxxxx     #導(dǎo)出xxxxxxx用戶下的表
TYPE COPY    #導(dǎo)出的對象比如VIEW诫龙、TABLE 等，具體請參考readme
ALLOW  xxxxxx  #允許導(dǎo)出xxxxxx用戶下的xxxxxx表
OUTPUT   outputcopy.sql   #導(dǎo)出的數(shù)據(jù)文件名稱
[root@bigdata01 ora2pg]# ora2pg -c ora2pg.mizu.conf.dist 
[========================>] 167/167 tables (100.0%) end of scanning.                           
[========================>] 78/78 rows (100.0%) Table advertmanagement (78 recs/sec)
[>                        ]       78/48491814 total rows (0.0%) - (0 sec., avg: 78 recs/sec).
[========================>] 126/126 rows (100.0%) Table auth_back_member (126 recs/sec)                     
[>                        ]      204/48491814 total rows (0.0%) - (0 sec., avg: 204 recs/sec).
[>                        ]      204/48491814 rows (0.0%) on total estimated data (1 sec., avg: 204 recs/sec)
[>                        ]      204/48491814 total rows (0.0%) - (0 sec., avg: 204 recs/sec).               
[========================>] 142/142 rows (100.0%) Table auth_back_member_role (142 recs/sec)                 
[>                        ]      346/48491814 total rows (0.0%) - (0 sec., avg: 346 recs/sec).
[>                        ]      346/48491814 rows (0.0%) on total estimated data (1 sec., avg: 346 recs/sec)
[>                        ]      346/48491814 total rows (0.0%) - (0 sec., avg: 346 recs/sec).               
[========================>] 1/1 rows (100.0%) Table auth_button_resource (1 recs/sec)                        
[>                        ]      347/48491814 total rows (0.0%) - (0 sec., avg: 347 recs/sec).
[>                        ]      347/48491814 rows (0.0%) on total estimated data (1 sec., avg: 347 recs/sec)
[>                        ]      347/48491814 total rows (0.0%) - (0 sec., avg: 347 recs/sec).               
[========================>] 79/79 rows (100.0%) Table auth_menu_resource (79 recs/sec)                       
[>                        ]      426/48491814 total rows (0.0%) - (0 sec., avg: 426 recs/sec).
[>                        ]      426/48491814 rows (0.0%) on total estimated data (1 sec., avg: 426 recs/sec)
[>                        ]      426/48491814 total rows (0.0%) - (0 sec., avg: 426 recs/sec).               
[========================>] 16/16 rows (100.0%) Table auth_role (16 recs/sec)                                
[>                        ]      442/48491814 total rows (0.0%) - (0 sec., avg: 442 recs/sec).

五线脚、導(dǎo)入到greenplum

[gpadmin@bigdata01 ~]$ psql -d test
psql (8.2.15)
Type "help" for help.
test=# \i /etc/ora2pg/outputcopy.sql

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者

人面猴
序言：七十年代末赐稽，一起剝皮案震驚了整個濱河市，隨后出現(xiàn)的幾起案子浑侥，更是在濱河造成了極大的恐慌姊舵，老刑警劉巖，帶你破解...
沈念sama閱讀 217,185評論 6贊 503
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件寓落，死亡現(xiàn)場離奇詭異括丁，居然都是意外死亡，警方通過查閱死者的電腦和手機伶选，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 92,652評論 3贊 393
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進店門史飞，熙熙樓的掌柜王于貴愁眉苦臉地迎上來尖昏，“玉大人，你說我怎么就攤上這事构资〕樗撸” “怎么了？”我有些...
開封第一講書人閱讀 163,524評論 0贊 353
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵吐绵，是天一觀的道長迹淌。經(jīng)常有香客問我，道長己单，這世上最難降的妖魔是什么唉窃？我笑而不...
開封第一講書人閱讀 58,339評論 1贊 293
?港島之戀（遺憾婚禮）
正文為了忘掉前任，我火速辦了婚禮纹笼，結(jié)果婚禮上纹份，老公的妹妹穿的比我還像新娘。我一直安慰自己廷痘，他們只是感情好蔓涧，可當(dāng)我...
茶點故事閱讀 67,387評論 6贊 391
惡毒庶女頂嫁案：這布局不是一般人想出來的
文/花漫我一把揭開白布。她就那樣靜靜地躺著牍疏，像睡著了一般蠢笋。火紅的嫁衣襯著肌膚如雪。梳的紋絲不亂的頭發(fā)上鳞陨，一...
開封第一講書人閱讀 51,287評論 1贊 301
城市分裂傳說
那天，我揣著相機與錄音瞻惋，去河邊找鬼厦滤。笑死，一個胖子當(dāng)著我的面吹牛歼狼，可吹牛的內(nèi)容都是我干的掏导。我是一名探鬼主播，決...
沈念sama閱讀 40,130評論 3贊 418
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開眼羽峰，長吁一口氣：“原來是場噩夢啊……” “哼趟咆！你這毒婦竟也來了？” 一聲冷哼從身側(cè)響起梅屉，我...
開封第一講書人閱讀 38,985評論 0贊 275
萬榮殺人案實錄
序言：老撾萬榮一對情侶失蹤值纱，失蹤者是張志新（化名）和其女友劉穎，沒想到半個月后坯汤，有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體虐唠，經(jīng)...
沈念sama閱讀 45,420評論 1贊 313
?護林員之死
正文獨居荒郊野嶺守林人離奇死亡，尸身上長有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點故事閱讀 37,617評論 3贊 334
?白月光啟示錄
正文我和宋清朗相戀三年惰聂，在試婚紗的時候發(fā)現(xiàn)自己被綠了疆偿。大學(xué)時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片咱筛。...
茶點故事閱讀 39,779評論 1贊 348
活死人
序言：一個原本活蹦亂跳的男人離奇死亡，死狀恐怖杆故，靈堂內(nèi)的尸體忽然破棺而出迅箩，到底是詐尸還是另有隱情，我是刑警寧澤处铛，帶...
沈念sama閱讀 35,477評論 5贊 345
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布沙热，位于F島的核電站，受9級特大地震影響罢缸，放射性物質(zhì)發(fā)生泄漏篙贸。R本人自食惡果不足惜，卻給世界環(huán)境...
茶點故事閱讀 41,088評論 3贊 328
男人毒藥：我在死后第九天來索命
文/蒙蒙一枫疆、第九天我趴在偏房一處隱蔽的房頂上張望爵川。院中可真熱鬧，春花似錦息楔、人聲如沸寝贡。這莊子的主人今日做“春日...
開封第一講書人閱讀 31,716評論 0贊 22
一樁弒父案值依，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽圃泡。三九已至，卻和暖如春愿险，著一層夾襖步出監(jiān)牢的瞬間颇蜡，已是汗流浹背。一陣腳步聲響...
開封第一講書人閱讀 32,857評論 1贊 269
情欲美人皮
我被黑心中介騙來泰國打工辆亏，沒想到剛下飛機就差點兒被人妖公主榨干…… 1. 我叫王不留风秤，地道東北人。一個月前我還...
沈念sama閱讀 47,876評論 2贊 370
代替公主和親
正文我出身青樓扮叨，卻偏偏與公主長得像缤弦，于是被迫代替她去往敵國和親。傳聞我的和親對象是個殘疾皇子彻磁，可洞房花燭夜當(dāng)晚...
茶點故事閱讀 44,700評論 2贊 354

使用ora2pg遷移oracle數(shù)據(jù)到greenplum

推薦閱讀更多精彩內(nèi)容