Patrick B wrote:
> I am running a background task on my DB, which will copy data from tableA to
> tableB. For
> that, I'm writing a PL/PGSQL function which basically needs to do the
> following:
>
>
> 1.Select the data from tableA
> 2.The limit will be put when calling the function
> 3.
Hi All,
I am going to migrate Oracle database into PostgreSQL using ora2pg tools.
I have installed Strawberry Perl.
C:\ora2pg>perl -v
This is perl 5, version 24, subversion 1 (v5.24.1) built for
MSWin32-x64-multi-thread
Copyright 1987-2017, Larry Wall
I am facing below issue while running belo
I am facing below issue while running below command.
*C:\ora2pg>ora2pg -c ora2pg.conf*
DBI connect('host=;sid=;port=',',...) failed:
ORA-01017: invalid username/p
assword; logon denied (DBD ERROR: OCISessionBegin) at
C:/Strawberry/perl/site/lib/Ora2Pg.pm line 1376.
FATAL: 1017 ... ORA-01017: in
On Mon, May 29, 2017 at 2:49 PM, Chris Mair wrote:
> I am facing below issue while running below command.
>>
>> *C:\ora2pg>ora2pg -c ora2pg.conf*
>> DBI connect('host=;sid=;port=',',...)
>> failed: ORA-01017: invalid username/p
>> assword; logon denied (DBD ERROR: OCISessionBegin) at
>> C:/Strawb
C:\ora2pg>ora2pg -c ora2pg.conf
[>] 2/2 tables (100.0%) end of scanning.
[>] 0/2 tables (0.0%) end of scanning.
[>] 2/2 tables (100.0%) end of table export.
Looks good so far.
This means you could connect to Oracle DB now.
On Mon, May 29, 2017 at 6:28 PM, Chris Mair wrote:
> C:\ora2pg>ora2pg -c ora2pg.conf
>> [>] 2/2 tables (100.0%) end of scanning.
>> [>] 0/2 tables (0.0%) end of scanning.
>> [>] 2/2 tables (100.0%) end of table export.
>>
>
>
[>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
[>] 1/2 total rows (50.0%) - (4 sec., avg: 0 recs/sec).
Out of memory!] 1/2 rows (50.0%) on total estimated data (4 sec.,
avg: 0 recs/sec)
Issuing rollback() due to DESTROY without explicit
On Mon, May 29, 2017 at 6:51 PM, Chris Mair wrote:
> [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
>> [>] 1/2 total rows (50.0%) - (4 sec., avg: 0
>> recs/sec).
>> Out of memory!] 1/2 rows (50.0%) on total estimated data (4
>> sec., avg
On Mon, May 29, 2017 at 6:54 PM, PAWAN SHARMA
wrote:
>
>
> On Mon, May 29, 2017 at 6:51 PM, Chris Mair wrote:
>
>> [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
>>> [>] 1/2 total rows (50.0%) - (4 sec., avg: 0
>>> recs/sec).
>>> Out of memory!
>>>
>>>
>> ya, but how can fix it.??
>>
>> because memory is not an issue on both the server.
>>
>
I've never used ora2pg but there is some documentation saying that
often an out of memory issue can be fixed by adjusting your DATA_LIMIT
setting. https://github.com/darold/ora2pg/blob/master/README#
On 05/29/2017 06:40 AM, PAWAN SHARMA wrote:
ya, but how can fix it.??
because memory is not an issue on both the server.
Hi Chris,
I am able to get the output script in output.sql but now data migration
is the big problem.
http://ora2pg.darold.net/documentation.html#postgresql_
*On this Memorial Day, Let us not forget the many that gave their lives so
that we can enjoy our Freedom today. I give thanks to all my fellow
veterans, and those still on active duty. May future generations still
remember us and grow to never know the horrors of war.Da Nang 1969->'70*
--
*Melvin
On Mon, May 29, 2017 at 7:17 PM, Adrian Klaver
wrote:
> On 05/29/2017 06:40 AM, PAWAN SHARMA wrote:
>
>>
>>
> ya, but how can fix it.??
>>
>> because memory is not an issue on both the server.
>>
>>
>> Hi Chris,
>>
>> I am able to get the output script in output.sql but now data migration
Hi everyone. I’m trying to perform some exact precision arithmetic with
PostgreSQL’s NUMERIC type. However I can’t seem to get the unparameterized
NUMERIC type to perform exact precision arithmetic:
# SELECT 2::NUMERIC ^ 64;
?column?
---
On Mon, May 29, 2017 at 4:19 PM, Kaiting Chen wrote:
> Hi everyone. I’m trying to perform some exact precision arithmetic with
> PostgreSQL’s NUMERIC type. However I can’t seem to get the unparameterized
> NUMERIC type to perform exact precision arithmetic:
>
> # SELECT 2::NUMERIC ^ 64;
>
Kaiting Chen writes:
> Hi everyone. I’m trying to perform some exact precision arithmetic with
> PostgreSQL’s NUMERIC type. However I can’t seem to get the unparameterized
> NUMERIC type to perform exact precision arithmetic:
Division is inherently inexact, except in special cases. If you thin
On Sun, May 28, 2017 at 9:41 AM, Ludovic Vaugeois-Pepin
wrote:
> On Sun, May 28, 2017 at 9:49 AM, Ludovic Vaugeois-Pepin
> wrote:
>> It really is set at 3s on all servers (master and standbies) earlier in the
>> "deployment" process at the same time "listen_addresses", "hot_standby", and
>> oth
On Tue, May 30, 2017 at 12:20 AM, Michael Paquier
wrote:
> On Sun, May 28, 2017 at 9:41 AM, Ludovic Vaugeois-Pepin
> wrote:
>> On Sun, May 28, 2017 at 9:49 AM, Ludovic Vaugeois-Pepin
>> wrote:
>>> It really is set at 3s on all servers (master and standbies) earlier in the
>>> "deployment" proce
18 matches
Mail list logo
