On Thu, 2017-11-09 at 17:01 +0530, Brahmam Eswar wrote:
> You can create a composite type in PostgreSQL:
> CREATE TYPE complex AS (r integer, i integer);
> You would use an array in this case:
> DECLARE
> carr complex[];
I've once faced the same thing, and did as Laurenz suggested.
You will like P
On Thu, 2017-11-09 at 17:01 +0530, Brahmam Eswar wrote:
> Here is the snippet of it.
>TYPE INV_LINES_RT IS RECORD(
> VENDOR_NUM A.Datastore.VENDOR_NUM%TYPE,
> VENDOR_SITE_CODE A.Datastore.VENDOR_SITE_CODE%TYPE,
> INVOICE_NUM A.Datastore.INVOICE_NUM%TYPE,
> T
Here is the snippet of it.
*Oracle :*
*Declaration part in Store Procedure*
CREATE OR REPLACE PROCEDURE "A"."Datastore"
(
, In_Param1 IN VARCHAR2
, In_Param2 IN VARCHAR2
, In_Param3 IN VARCHAR2
, Out_Param1 OUT VARCHAR2
, ERROR_MSG OUT VARCHAR2
) AS
TEMP_ERR_MSG VARCHAR2(4000);
IS
Brahmam Eswar wrote:
> How to migrate the Oracle collection types ( IsTableOF, IsRecord) to postgres.
Are you talking about table definitions or PL/SQL code?
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
Hi ,
How to migrate the Oracle collection types ( IsTableOF, IsRecord) to
postgres.
--
Thanks & Regards,
Brahmeswara Rao J.
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
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_
>>>
>>>
>> 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 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!
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
[>] 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: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.
>>
>
>
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 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
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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Le 08/07/2015 22:25, CS DBA a écrit :
>
>
> On 07/08/2015 02:20 PM, John R Pierce wrote:
>> On 7/8/2015 1:16 PM, dinesh kumar wrote:
>>> We recently done the similar migration for one of our customer.
>>> We used all opensource tools to achieve this
On Wed, Jul 8, 2015 at 5:20 PM, Joshua D. Drake
wrote:
>
> On 07/08/2015 12:47 PM, John McKown wrote:
>
>
>> Why are they converting?
>>
>> Would EnterpriseDB (a commercial version of PostgreSQL which has
>> extensions to make it a "drop in" replacement for Oracle) be a
>> possibility?
>> http:
I would start by looking at how many databases, schemas, tables and views
are involved. Then look at how many individual Oracle functions need to be
converted to plpgsql. You also need to investigate if there are any custom
data types. I do not have the formula, but I am sure there is a general
tim
On 07/08/2015 12:47 PM, John McKown wrote:
Why are they converting?
Would EnterpriseDB (a commercial version of PostgreSQL which has
extensions to make it a "drop in" replacement for Oracle) be a possibility?
http://www.enterprisedb.com/solutions/oracle-compatibility-technology
Because EDB
On Wed, Jul 8, 2015 at 1:20 PM, John R Pierce wrote:
> On 7/8/2015 1:16 PM, dinesh kumar wrote:
>
>> We recently done the similar migration for one of our customer. We used
>> all opensource tools to achieve this migration process.
>>
>> We used Pentaho Data Integration tool for doing Online DB m
On 07/08/2015 02:20 PM, John R Pierce wrote:
> On 7/8/2015 1:16 PM, dinesh kumar wrote:
>> We recently done the similar migration for one of our customer. We
>> used all opensource tools to achieve this migration process.
>>
>> We used Pentaho Data Integration tool for doing Online DB migration,
On 7/8/2015 1:16 PM, dinesh kumar wrote:
We recently done the similar migration for one of our customer. We
used all opensource tools to achieve this migration process.
We used Pentaho Data Integration tool for doing Online DB migration,
which took minimal downtime with CDC{Change Data Capture
Hi,
We recently done the similar migration for one of our customer. We used all
opensource tools to achieve this migration process.
We used Pentaho Data Integration tool for doing Online DB migration, which
took minimal downtime with CDC{Change Data Capture} approach. Also, we used
Ora2Pg tool to
On Wed, Jul 8, 2015 at 2:24 PM, Tim Clotworthy <
tclotwor...@bluestonelogic.com> wrote:
> Hello,
>
> I have a customer that is about to undertake a migration of an Oracle 11g
> database to PostgreSQL 9.x (exact version to be determined). I am talking
> not only of the migration of schemas and data
This is almost exactly what we did around 8 years ago; obviously the
version numbers have changed. The reason we chose Postgres was the
enormous similarity between the two languages plus the overwhelming ROI
on the migration; my CEO had a spontaneous nosebleed when the Oracle
licensing costs were r
Hello,
I have a customer that is about to undertake a migration of an Oracle 11g
database to PostgreSQL 9.x (exact version to be determined). I am talking
not only of the migration of schemas and data, but also of a substantial
codebase of Pl/SQL stored procedures, as well as many triggers.
I don
Hi
With minimal application code changes we are able to migrate database from
Oracle to PostgreSQL successfully (including performance issues) on
production
This we did on high read intensive database sized 900+GB
Thanks to PostgreSQL
Thanks
Sridhar BN
Sameer Kumar wrote:
> I guess I will be exploring more on oracle foreign data wrapper.
>
> Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would
> it handle failovers.
I have not tried it, but it should work as follows:
- You'll have to use a connect string that is correct
Rajni Baliyan, 09.05.2014 09:46:
> I downloaded symmetricDS but I did not found any installer
> (symmetric-pro-x.x.x.jar)
> Can any one please help me in this
This might help:
http://www.symmetricds.org/doc/3.5/html/tutorial.html#tutorial-install
--
Sent via pgsql-general mailing list (pg
mates.com> wrote:
> We use symmetricDS for this. Works pretty well.
>
> http://www.symmetricds.org/
>
>
> From: Serge Fonville
> Date: Wednesday, May 7, 2014 at 2:49 AM
> To: Geoff Montee
> Cc: Sameer Kumar , PostgreSQL General Discussion
> Forum
> Subject: R
PostgreSQL General Discussion Forum
mailto:pgsql-general@postgresql.org>>
Subject: Re: [GENERAL] Oracle to PostgreSQL replication
Hi,
I need to setup a replication process for continuously replicating changes
happening in an Oracle Database to a PostgreSQL database.
My Oracle Database is ver
You can test with SymmetricDS (www.*symmetricds*.org)
On Thu, May 8, 2014 at 10:35 PM, tuanhoanganh wrote:
> You can test with SymmetricDS (www.*symmetricds*.org)
>
>
> On Thu, May 8, 2014 at 12:53 PM, Sameer Kumar wrote:
>
>>
>> Thanks alot everyone!
>>
>> I guess I will be exploring more on o
Thanks alot everyone!
I guess I will be exploring more on oracle foreign data wrapper.
Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would
it handle failovers.
Hi,
I need to setup a replication process for continuously replicating changes
> happening in an Oracle Database to a PostgreSQL database.
>
> My Oracle Database is version 11.2 and setup as a cluster with RAC
> My Postgres database version is 9.2
>
> Oracle Database is running in Solaris and Post
On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar wrote:
> Hi,
>
>
> I need to setup a replication process for continuously replicating changes
> happening in an Oracle Database to a PostgreSQL database.
>
>
> My Oracle Database is version 11.2 and setup as a cluster with RAC
> My Postgres database ve
Sameer Kumar wrote:
> I need to setup a replication process for continuously replicating changes
> happening in an Oracle
> Database to a PostgreSQL database.
>
>
> My Oracle Database is version 11.2 and setup as a cluster with RAC
> My Postgres database version is 9.2
>
> Oracle Database is ru
Hi,
I need to setup a replication process for continuously replicating changes
happening in an Oracle Database to a PostgreSQL database.
My Oracle Database is version 11.2 and setup as a cluster with RAC
My Postgres database version is 9.2
Oracle Database is running in Solaris and PostgreSQL i
2013/4/5 Robert Treat :
>
> Yeah, it's worth reading through those links to get an idea of things;
> you'll find much less literature (and tools) for MSSQL, but the
> principals are mostly the same. One thing to decide on is if you are
> going to port applications wholesale, or try to run some kind
On 04/05/2013 08:03 AM, Robert Treat wrote:
On Fri, Apr 5, 2013 at 2:12 AM, Szymon Guz wrote:
On 4 April 2013 16:16, Roy Anderson wrote:
Hey all,
We have a very robust Oracle and SQL Server presence at work but we're
looking to farm out some of the load to PostgreSQL to limit costs. I'm
c
On 04/04/2013 09:16 AM, Roy Anderson wrote:
We have a very robust Oracle and SQL Server presence at work but we're
looking to farm out some of the load to PostgreSQL to limit costs.
You can do what we did. EnterpriseDB has built-in Oracle compatibility
through a series of plugins, patches, an
On Fri, Apr 5, 2013 at 2:12 AM, Szymon Guz wrote:
> On 4 April 2013 16:16, Roy Anderson wrote:
>>
>> Hey all,
>>
>> We have a very robust Oracle and SQL Server presence at work but we're
>> looking to farm out some of the load to PostgreSQL to limit costs. I'm
>> curious if there are any DBAs out
On Thu, Apr 4, 2013 at 11:16 PM, Roy Anderson wrote:
> Hey all,
>
> We have a very robust Oracle and SQL Server presence at work but we're
> looking to farm out some of the load to PostgreSQL to limit costs. I'm
> curious if there are any DBAs out there who have gone down this route
> before. Any
On 4 April 2013 16:16, Roy Anderson wrote:
> Hey all,
>
> We have a very robust Oracle and SQL Server presence at work but we're
> looking to farm out some of the load to PostgreSQL to limit costs. I'm
> curious if there are any DBAs out there who have gone down this route
> before. Any tips, tri
Hey all,
We have a very robust Oracle and SQL Server presence at work but we're
looking to farm out some of the load to PostgreSQL to limit costs. I'm
curious if there are any DBAs out there who have gone down this route
before. Any tips, tricks, failures, successes, etc.? I would just like to
hea
Hello all,
GoldenGate added PostgreSQL as a target database for replication. I tried
setting it up, and not finding any tutorial, put together a how to here -
http://jayadevanm.wordpress.com/2012/11/07/goldengate-replication-from-oracle-to-postgresql/
I think near real-time replication might have q
Thomas Kellerer wrote:
change number to numeric, and varchar2 to char and you'll likely be
good.
My guess would have been that varchar is the equivalent to varchar2
char does a blank padding and is different in behaviour to varchar (as
it is in Oracle)
geez, yeah, what you said!BT
John R Pierce wrote on 16.03.2009 00:41:
Greenhorn wrote:
Unfortunately When I execute the above files using \i I am getting
errors like
ERROR: syntax error at or near "("
LINE 4: SUB_TYPE NUMBER(3) NOT NULL,
Obviously 'number' is not PostgreSQL data type so is '
Greenhorn wrote:
Unfortunately When I execute the above files using \i I am getting errors like
ERROR: syntax error at or near "("
LINE 4: SUB_TYPE NUMBER(3) NOT NULL,
Obviously 'number' is not PostgreSQL data type so is 'varchar2'. What
is your suggestion to crea
Hi,
I have almost 1300 files from Oracle (no access to oracle server). I
have to create the tables and data as follows.
-- start script
-- file name: aa_asset_type.sql
CREATE TABLE AS_ASSET_TYPE
(
MAIN_TYPE CHAR(3) NOT NULL,
SUB_TYPE NUMBER(3)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/09/07 14:53, Chris Fischer wrote:
> All of Oracle's (non-float) number types are variable size
> numbers with an ordinal and a mantissa. This makes Oracle number
> very efficient for smaller values as compared to fixed size
> integers, but less
EMAIL PROTECTED] On Behalf Of Scott Marlowe
Sent: Friday, March 09, 2007 1:58 PM
To: Devrim GÜNDÜZ
Cc: Shane Ambler; Kevin Hunter; [EMAIL PROTECTED]; PostgreSQL General List
Subject: Re: [GENERAL] "oracle to postgresql" conversion
On Thu, 2007-03-08 at 16:05, Devrim GÜNDÜZ wrote:
> Hi,
>
On Thu, 2007-03-08 at 16:05, Devrim GÜNDÜZ wrote:
> Hi,
>
> On Fri, 2007-03-09 at 05:21 +1030, Shane Ambler wrote:
> > NUMBER is Oracle's version of NUMERIC - Oracle will use both but
> > probably only Oracle will use NUMBER.
>
> Really? I thought Oracle's NUMBER ~ PostgreSQL's (BIG)INT?
Not s
Hi,
On Fri, 2007-03-09 at 05:21 +1030, Shane Ambler wrote:
> NUMBER is Oracle's version of NUMERIC - Oracle will use both but
> probably only Oracle will use NUMBER.
Really? I thought Oracle's NUMBER ~ PostgreSQL's (BIG)INT?
/me looks at Oracle docs again.
--
Devrim GÜNDÜZ
PostgreSQL Replic
On Tue, 2007-03-06 at 11:01, [EMAIL PROTECTED] wrote:
> I'm a newbie in Oracle and postgreSQL,
> i'm need to translate the following script (in Oracle) to postgreSQL :
>
> rem Autorisation des lignes vides :
> set sqlbl on
You don't need this, postgresql doesn't choke on extra lines.
> rem Initi
Kevin Hunter wrote:
On 06 Mar 2007 at 9:01a -0800, g.c[ altudela ] wrote:
I'm a newbie in Oracle and postgreSQL,
i'm need to translate the following script (in Oracle) to postgreSQL :
rem Autorisation des lignes vides :
set sqlbl on
rem Initialisation du timer :
set timing on
rem Creation de
On Thursday 08 March 2007 11:40:21 am Kevin Hunter wrote:
> I do not know what the setting 'sqlbl' does in Oracle.
SET SQLBLANKLINES ON makes sqlplus not choke on empty lines in your input.
Don't get me started.
jan
--
--
Jan de Vis
On 06 Mar 2007 at 9:01a -0800, g.c[ altudela ] wrote:
I'm a newbie in Oracle and postgreSQL,
i'm need to translate the following script (in Oracle) to postgreSQL :
rem Autorisation des lignes vides :
set sqlbl on
rem Initialisation du timer :
set timing on
rem Creation de la table :
CREATE TA
I'm a newbie in Oracle and postgreSQL,
i'm need to translate the following script (in Oracle) to postgreSQL :
rem Autorisation des lignes vides :
set sqlbl on
rem Initialisation du timer :
set timing on
rem Creation de la table :
CREATE TABLE "LEPAPE"."EXPERIENCE"(
"EXP_ID" VARCHAR2(16
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I think that's been part of pgadmin 2
On Monday 08 December 2003 10:49 pm, Randy Harris wrote:
> I've been scouring the PostgreSQL web site and have found several
> references to a Database Migration Wizard. I was unable, however, to find
> any deta
60 matches
Mail list logo
