>
> BEGIN
> EXECUTE IMMEDIATE 'DROP TABLE CONTAINER';
> EXCEPTION
> WHEN OTHERS THEN
>IF SQLCODE != -942 THEN
> RAISE;
>END IF;
> END;
>
Jim nailed it. In PostgreSQL, this is just
DROP TABLE IF EXISTS CONTAINER;
One line. No dynamic SQL, exception block, or even
On 2/2/15 9:13 PM, Jim Nasby wrote:
On 1/29/15 3:02 PM, Adrian Klaver wrote:
On 01/29/2015 03:16 AM, Ramesh T wrote:
hello,
can any one help me to convert oracle to postgres script..?
following code ..
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE CONTAINER';
EXCEPTION
WHEN OTHERS THEN
IF
On 1/29/15 3:02 PM, Adrian Klaver wrote:
On 01/29/2015 03:16 AM, Ramesh T wrote:
hello,
can any one help me to convert oracle to postgres script..?
following code ..
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE CONTAINER';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -942 THEN
RAISE;
On 1/29/2015 1:02 PM, Adrian Klaver wrote:
Not sure about that state code. I could not find it here:
http://www.postgresql.org/docs/9.3/interactive/errcodes-appendix.html
I believe SQLCODE = -942 is the same as ORA-00942, which is 'table or
view does not exist'. I /think/ (but won't vouch)
On 01/29/2015 03:16 AM, Ramesh T wrote:
hello,
can any one help me to convert oracle to postgres script..?
following code ..
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE CONTAINER';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -942 THEN
RAISE;
END IF;
END;
advance thanks,
For
On Thu, Jul 07, 2011 at 12:01:56PM -0400, akp geek wrote:
> Thank you all for the responses. All we have is just table migrations, no
> procedures, triggers involved. I will try to do the migration using ora2pg.
> I downloaded it, while installing it I am getting an error. Will try to
> resolve tha
Craig Ringer
>
> Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
> To: "akp geek"
> Cc: "pgsql-general"
> Date: Thursday, July 7, 2011, 2:02 PM
>
> On 7/07/2011 9:55 PM, akp geek wrote:
> > Hi all -
> >
> >
--- On Thu, 7/7/11, Craig Ringer wrote:
From: Craig Ringer
Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
To: "akp geek"
Cc: "pgsql-general"
Date: Thursday, July 7, 2011, 2:02 PM
On 7/07/2011 9:55 PM, akp geek wrote:
> Hi all -
>
>
On 07/07/2011 15:21, salah jubeh wrote:
>
> Hello,
>
> I do no have any experience with oracle, try to dump the oracle database in
plain format and then try to execute the DDL and DML statements. It might be
cumbersome to fix all the errors you might get.
> But as an initial solution give it a s
From: casp
To: pgsql-general@postgresql.org
Cc: cesulba...@gmail.com
Sent: Thu, July 7, 2011 4:05:32 PM
Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
Good truth migration between Oracle and PostgreSQL are not things
difficult:
Indicates that your database has
On Thu, Jul 07, 2011 at 09:55:45AM -0400, akp geek wrote:
> Hi all -
>
>Are there any open source tools available for migrating from
> oracle to postgres. We have 20 tables in oracles that we needed to get to
> postgres. Appreciate your help
I have used ora2pg. It was not seamles
Good truth migration between Oracle and PostgreSQL are not things
difficult:
Indicates that your database has:
Tables: 20
Shema:?
functions:?
Views:?
They need help to migrate ... Or what are you suggestions if you need a
tool that already does this task for you good people have a tool
interprise
On 7/07/2011 9:55 PM, akp geek wrote:
Hi all -
Are there any open source tools available for migrating
from oracle to postgres. We have 20 tables in oracles that we needed to
get to postgres. Appreciate your help
One avenue you may wish to investigate is ETL tools like Talend.
Hi all -
Are there any open source tools available for migrating from
oracle to postgres. We have 20 tables in oracles that we needed to get to
postgres. Appreciate your help
Regards
14 matches
Mail list logo
