pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAny documatation about porting from Oracle to PostgreSQL
7+ messages / 7 participants
[nested] [flat]
* Any documatation about porting from Oracle to PostgreSQL
@ 2006-10-17 07:50 Felix Zhang <felix.zhang.2005@gmail.com>
0 siblings, 3 replies; 7+ messages in thread
From: Felix Zhang @ 2006-10-17 07:50 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org; pgsql-novice@postgresql.org
Hi all,
I'm a newbie of PostgreSQL. I'm searching materials about porting from
Oracle to PostgreSQL.
Anyone can share with me some good documatations?
Thanks and regards,
Felix
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Any documatation about porting from Oracle to PostgreSQL
@ 2006-10-17 08:36 Andreas Kretschmer <akretschmer@spamfence.net>
parent: Felix Zhang <felix.zhang.2005@gmail.com>
2 siblings, 1 reply; 7+ messages in thread
From: Andreas Kretschmer @ 2006-10-17 08:36 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-sql; pgsql-novice@postgresql.org
Felix Zhang <felix.zhang.2005@gmail.com> schrieb:
> Hi all,
>
> I'm a newbie of PostgreSQL. I'm searching materials about porting from Oracle
> to PostgreSQL.
> Anyone can share with me some good documatations?
http://techdocs.postgresql.org/#convertfrom
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Any documatation about porting from Oracle to PostgreSQL
@ 2006-10-17 08:44 Thomas Kellerer <spam_eater@gmx.net>
parent: Andreas Kretschmer <akretschmer@spamfence.net>
0 siblings, 1 reply; 7+ messages in thread
From: Thomas Kellerer @ 2006-10-17 08:44 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: pgsql-novice@postgresql.org; pgsql-sql
On 17.10.2006 10:36 Andreas Kretschmer wrote:
>
> http://techdocs.postgresql.org/#convertfrom
>
I just noticed that the link "Porting from Oracle PL/SQL" still points
to the 7.4 manuals. Shouldn't that be updated to point to the current
release?
And the link "Ora2Pg - Oracle to PostgreSQL database schema converter"
(http://techdocs.postgresql.org/redir.php?link=http://www.samse.fr/GPL/ora2pg/ora2pg.html)
gives a 404 error.
Thomas
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Any documatation about porting from Oracle to PostgreSQL
@ 2006-10-17 09:36 A. Kretschmer <andreas.kretschmer@schollglas.com>
parent: Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 1 reply; 7+ messages in thread
From: A. Kretschmer @ 2006-10-17 09:36 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-novice@postgresql.org; pgsql-sql
am Tue, dem 17.10.2006, um 10:44:52 +0200 mailte Thomas Kellerer folgendes:
> On 17.10.2006 10:36 Andreas Kretschmer wrote:
> >
> >http://techdocs.postgresql.org/#convertfrom
> >
>
> I just noticed that the link "Porting from Oracle PL/SQL" still points
> to the 7.4 manuals. Shouldn't that be updated to point to the current
> release?
>
> And the link "Ora2Pg - Oracle to PostgreSQL database schema converter"
>
> (http://techdocs.postgresql.org/redir.php?link=http://www.samse.fr/GPL/ora2pg/ora2pg.html)
>
> gives a 404 error.
Sorry.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Any documatation about porting from Oracle to PostgreSQL
@ 2006-10-17 10:25 Shane Ambler <pgsql@007Marketing.com>
parent: Felix Zhang <felix.zhang.2005@gmail.com>
2 siblings, 0 replies; 7+ messages in thread
From: Shane Ambler @ 2006-10-17 10:25 UTC (permalink / raw)
To: Felix Zhang <felix.zhang.2005@gmail.com>; +Cc: pgsql-general@postgresql.org
Felix Zhang wrote:
> Hi all,
>
> I'm a newbie of PostgreSQL. I'm searching materials about porting from
> Oracle to PostgreSQL.
> Anyone can share with me some good documatations?
>
> Thanks and regards,
> Felix
>
A quick search of pgfoundry finds
http://pgfoundry.org/projects/orafce/
which may help.
Depending on your needs and plans have you looked at EnterpriseDB?
They claim to run most Oracle stuff straight up. Their free version will
run on 1cpu with up to 4GB data and 1GB RAM.
--
Shane Ambler
Postgres@007Marketing.com
Get Sheeky @ http://Sheeky.Biz
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL]Any documatation about porting from Oracle to PostgreSQL
@ 2006-10-17 13:20 Lewis Cunningham <lewisc@rocketmail.com>
parent: Felix Zhang <felix.zhang.2005@gmail.com>
2 siblings, 0 replies; 7+ messages in thread
From: Lewis Cunningham @ 2006-10-17 13:20 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org; pgsql-novice@postgresql.org
Felix,
You might want to look at EnterpriseDB, which is PostgreSQL with
Oracle compatibility extensions.
www.enterprisedb.com
LewisC
--- Felix Zhang <felix.zhang.2005@gmail.com> wrote:
> Hi all,
>
> I'm a newbie of PostgreSQL. I'm searching materials about porting
> from
> Oracle to PostgreSQL.
> Anyone can share with me some good documatations?
>
> Thanks and regards,
> Felix
>
-----------------------------------------------------------
Lewis R Cunningham
ItToolBox Blog: An Expert's Guide to Oracle
http://blogs.ittoolbox.com/oracle/guide/
EnterpriseDB: The Definitive Reference
http://www.rampant-books.com/book_2007_1_enterprisedb.htm
----------------------------------------------------------
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Any documatation about porting from Oracle to PostgreSQL
@ 2006-10-19 01:57 Robert Treat <xzilla@users.sourceforge.net>
parent: A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 0 replies; 7+ messages in thread
From: Robert Treat @ 2006-10-19 01:57 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: A. Kretschmer <andreas.kretschmer@schollglas.com>; pgsql-novice@postgresql.org, pgsql-sql@postgresql.org, "Felix Zhang" <felix.zhang.2005@gmail.com>
On Tuesday 17 October 2006 05:36, A. Kretschmer wrote:
> am Tue, dem 17.10.2006, um 10:44:52 +0200 mailte Thomas Kellerer folgendes:
> > On 17.10.2006 10:36 Andreas Kretschmer wrote:
> > >http://techdocs.postgresql.org/#convertfrom
> >
> > I just noticed that the link "Porting from Oracle PL/SQL" still points
> > to the 7.4 manuals. Shouldn't that be updated to point to the current
> > release?
> >
> > And the link "Ora2Pg - Oracle to PostgreSQL database schema converter"
> >
> > (http://techdocs.postgresql.org/redir.php?link=http://www.samse.fr/GPL/or
> >a2pg/ora2pg.html)
> >
> > gives a 404 error.
>
> Sorry.
>
Not your fault... the whole techdocs site really needs to go away but the pg
webmasters haven't gotten around to it (mostly me in this particular case)
Felix, in case your still watching, a (in theory) more up to date link would
be found at http://www.postgresql.org/docs/techdocs.3. Oh, and please don't
crosspost across 3 different lists in the future, it just creates noise for
the rest of us.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2006-10-19 01:57 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-17 07:50 Any documatation about porting from Oracle to PostgreSQL Felix Zhang <felix.zhang.2005@gmail.com>
2006-10-17 08:36 ` Andreas Kretschmer <akretschmer@spamfence.net>
2006-10-17 08:44 ` Thomas Kellerer <spam_eater@gmx.net>
2006-10-17 09:36 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-10-19 01:57 ` Robert Treat <xzilla@users.sourceforge.net>
2006-10-17 10:25 ` Shane Ambler <pgsql@007Marketing.com>
2006-10-17 13:20 ` Lewis Cunningham <lewisc@rocketmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox