Skip site navigation (1) Skip section navigation (2)

Using ora2pg Perl Script

From: "Doug Pisarek" <dgp(at)strata-group(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Using ora2pg Perl Script
Date: 2009-09-09 14:18:34
Message-ID: 404990009113F448B0DB29FE65110168BA3FF3@sbs2003.StrataGroup.local (view raw or flat)
Thread:
Lists: pgsql-novice
Trying to run ora2pg Perl Script. I would like to know what site I can
go to get the perl modules to run this ora2pg script.
I am receiving this error:
perl ora2pg.pl
Can't locate IO/Compress/Base/Common.pm in @INC (@INC contains:
/oracle10g/OraHome1/perl/lib/site_perl/5.8.3/HTTP/Request
/usr/perl5/5.8.4/lib/sun4-solaris-64int /usr/perl5/5.8.4/lib
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int /usr/perl5/site_perl/5.8.4
/usr/perl5/site_perl /usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int
/usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl .) at
/usr/perl5/site_perl/5.8.4/Compress/Zlib.pm line 11.
BEGIN failed--compilation aborted at
/usr/perl5/site_perl/5.8.4/Compress/Zlib.pm line 11.
Compilation failed in require at Ora2Pg.pm line 429.
BEGIN failed--compilation aborted at Ora2Pg.pm line 429.
Compilation failed in require at ./ora2pg.pl line 12.
BEGIN failed--compilation aborted at ./ora2pg.pl line 12.

Here are the perl modules I have compiled with my perl:
 
 >perl chk_mod.pl
Compress::Zlib -- 2.015
Compress::Zlib::Perl -- 0.02
DBI -- 1.51
Perl -- 5.8.4
 
perl -V 
 
Summary of my perl5 (revision 5 version 8 subversion 4) configuration:
  Platform:
    osname=solaris, osvers=2.10, archname=sun4-solaris-64int
    uname='sunos localhost 5.10 sun4u sparc SUNW,Ultra-2'
    config_args=''
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=define use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-xarch=v8 -D_TS_ERRNO',
    optimize='-xO3 -xspace -xildoff',
    cppflags=''
    ccversion='Sun WorkShop', gccversion='', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t', lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =''
    libpth=/lib /usr/lib /usr/ccs/lib
    libs=-lsocket -lnsl -ldl -lm -lc
    perllibs=-lsocket -lnsl -ldl -lm -lc
    libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R
/usr/perl5/5.8.4/lib/sun4-solaris-64int/CORE'
    cccdlflags='-KPIC', lddlflags='-G'
 

Characteristics of this binary (from libperl):
  Compile-time options: USE_64_BIT_INT USE_LARGE_FILES
  Locally applied patches:
        22667 The optree builder was looping when constructing the ops
...
        22715 Upgrade to FileCache 1.04
        22733 Missing copyright in the README.
        22746 fix a coredump caused by rv2gv not fully converting a PV
...
        22755 Fix 29149 - another UTF8 cache bug hit by substr.
        22774 [perl #28938] split could leave an array without ...
        22775 [perl #29127] scalar delete of empty slice returned
garbage
        22776 [perl #28986] perl -e "open m" crashes Perl
        22777 add test for change #22776 ("open m" crashes Perl)
        22778 add test for change #22746 ([perl #29102] Crash on assign
...
        22781 [perl #29340] Bizarre copy of ARRAY make sure a pad op's
...
        22796 [perl #29346] Double warning for int(undef) and abs(undef)
...
        22818 BOM-marked and (BOMless) UTF-16 scripts not working
        22823 [perl #29581] glob() misses a lot of matches
        22827 Smoke [5.9.2] 22818 FAIL(F) MSWin32 WinXP/.Net SP1 (x86/1
cpu)
        22830 [perl #29637] Thread creation time is hypersensitive
        22831 improve hashing algorithm for ptr tables in perl_clone:
...
        22839 [perl #29790] Optimization busted: '@a <mailto:'@a>  =
"b", sort @a' ...
        22850 [PATCH] 'perl -v' fails if local_patches contains code
snippets
        22852 TEST needs to ignore SCM files
        22886 Pod::Find should ignore SCM files and dirs
        22888 Remove redundant %SIG assignments from FileCache
        23006 [perl #30509] use encoding and "eq" cause memory leak
        23074 Segfault using HTML::Entities
        23106 Numeric comparison operators mustn't compare addresses of
...
        23320 [perl #30066] Memory leak in nested shared data structures
...
        23321 [perl #31459] Bug in read()
        27722 perlio.c breaks on Solaris/gcc when > 256 FDs are
available
        SPRINTF0 - fixes for sprintf formatting issues - CVE-2005-3962
  Built under solaris
  Compiled at Aug  8 2007 19:08:30
  @INC:
    /usr/perl5/5.8.4/lib/sun4-solaris-64int
    /usr/perl5/5.8.4/lib
    /usr/perl5/site_perl/5.8.4/sun4-solaris-64int
    /usr/perl5/site_perl/5.8.4
    /usr/perl5/site_perl
    /usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int
    /usr/perl5/vendor_perl/5.8.4
    /usr/perl5/vendor_perl
 
 
Thanks,
Doug P.



 

Responses

pgsql-novice by date

Next:From: Salva TriadoDate: 2009-09-09 15:39:55
Subject: Download postgresql 7.4.1 windows
Previous:From: Raimon FernandezDate: 2009-09-09 10:16:08
Subject: Re: different results using count(x)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group