pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feed Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration)
4+ messages / 4 participants
[nested] [flat]
* Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration)
@ 2022-12-23 09:37 Chetan Kosanam <chetan.kosanam@tcs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Chetan Kosanam @ 2022-12-23 09:37 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>; Veerraju Yeluduti <veerraju.y@tcs.com>
TCS Confidential
Hi Support@ PostgreSQL Team,
Greetings !!
We are operating within one of the AWS business units of TCS. Our team is working on the Database migration from Oracle(on Amazon EC2) to PostgreSQL. The reason for this e-mailer is to seek your earnest required support from you on the Alternative functionalities from Oracle --> PostgreSQL while migrating the Oracle database to PostgreSQL.
S. No.
Oracle functionalities
PostgreSQL Equivalent
1
dbms_lob . --> ( createtemporary , OPEN , lob_readwrite , getlength , writeappend , SUBSTR )
Need the respective equivalent for the Oracle functionalities present in the adjoining column
2
dbms_sql
3
dbms_utility
4
utl_http.begin_request
5
DBMS_LDAP
6
UTL_RAW . --> ( cast_to_varchar2 , LENGTH , cast_to_raw )
In case we don’t have any exact equivalent, please advise on the methodology to get the needful done.
Thanks & Regards,
Chetan Kosanam
TCS, HYDERABAD
Contact : 9502753544
Mailto : chetan.kosanam@tcs.com
TCS Confidential
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration)
@ 2022-12-28 17:45 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Chetan Kosanam <chetan.kosanam@tcs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Adrian Klaver @ 2022-12-28 17:45 UTC (permalink / raw)
To: Chetan Kosanam <chetan.kosanam@tcs.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>; Veerraju Yeluduti <veerraju.y@tcs.com>
On 12/23/22 01:37, Chetan Kosanam wrote:
> TCS Confidential
>
>
> Hi *Support*@ *PostgreSQL* Team,
>
> *Greetings* *!!*
>
> **
>
> **We are operating within one of the /AWS business/ units of *TCS*. Our
> team is working on the *Database migration from Oracle(on Amazon EC2) to
> PostgreSQL*. The reason for this e-mailer is to seek your earnest
> required support from you on the *Alternative functionalities from
> Oracle **à PostgreSQL* while migrating the Oracle database to PostgreSQL.
See here:
https://www.postgresql.org/support/professional_support/
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration)
@ 2022-12-29 02:15 rob stone <floriparob@tpg.com.au>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 4+ messages in thread
From: rob stone @ 2022-12-29 02:15 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; Chetan Kosanam <chetan.kosanam@tcs.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>; Veerraju Yeluduti <veerraju.y@tcs.com>
On Wed, 2022-12-28 at 09:45 -0800, Adrian Klaver wrote:
> On 12/23/22 01:37, Chetan Kosanam wrote:
> > TCS Confidential
> >
> >
>
> See here:
>
> https://www.postgresql.org/support/professional_support/
>
>
Also there is ora2pg. See https://ora2pg.darold.net/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration)
@ 2022-12-29 02:17 Ron <ronljohnsonjr@gmail.com>
parent: rob stone <floriparob@tpg.com.au>
0 siblings, 0 replies; 4+ messages in thread
From: Ron @ 2022-12-29 02:17 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On 12/28/22 20:15, rob stone wrote:
>
> On Wed, 2022-12-28 at 09:45 -0800, Adrian Klaver wrote:
>> On 12/23/22 01:37, Chetan Kosanam wrote:
>>> TCS Confidential
>>>
>>>
>> See here:
>>
>> https://www.postgresql.org/support/professional_support/
>>
>>
> Also there is ora2pg. See https://ora2pg.darold.net/
That does a great job at data conversion. Not sure about functionality
conversion.
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-12-29 02:17 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-23 09:37 Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) Chetan Kosanam <chetan.kosanam@tcs.com>
2022-12-28 17:45 ` Adrian Klaver <adrian.klaver@aklaver.com>
2022-12-29 02:15 ` rob stone <floriparob@tpg.com.au>
2022-12-29 02:17 ` Ron <ronljohnsonjr@gmail.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