From: Chetan Kosanam <chetan.kosanam@tcs.com>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>
Cc: Md Rakibuddin <md.rakibuddin@tcs.com>
Cc: SAI CHANDANA CHAMALA <sc.chamala@tcs.com>
Cc: Sandu Sai Prasad <saiprasad.sandu@tcs.com>
Cc: UPPALA NIKHITA <venkata.uppala@tcs.com>
Cc: Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>
Cc: Mohammed Imran <imran.mohammed@tcs.com>
Cc: Kotha Parvathi <kotha.parvathi@tcs.com>
Cc: Uma Puttappa <uma.puttappa@tcs.com>
Cc: Veerraju Yeluduti <veerraju.y@tcs.com>
Subject: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration)
Date: Fri, 23 Dec 2022 09:37:34 +0000
Message-ID: <MAXPR01MB2688DD8FDA61430C16DD584C9EE99@MAXPR01MB2688.INDPRD01.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <MAXPR01MB2688CFCA349F11FAD7B495EB9EEB9@MAXPR01MB2688.INDPRD01.PROD.OUTLOOK.COM>
References: <MAXPR01MB2688CFCA349F11FAD7B495EB9EEB9@MAXPR01MB2688.INDPRD01.PROD.OUTLOOK.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: chetan.kosanam@tcs.com, harinarayana.kadiyala@tcs.com, md.rakibuddin@tcs.com, sc.chamala@tcs.com, saiprasad.sandu@tcs.com, venkata.uppala@tcs.com, sai.gantimahapatruni@tcs.com, imran.mohammed@tcs.com, kotha.parvathi@tcs.com, uma.puttappa@tcs.com, veerraju.y@tcs.com
Subject: Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration)
In-Reply-To: <MAXPR01MB2688DD8FDA61430C16DD584C9EE99@MAXPR01MB2688.INDPRD01.PROD.OUTLOOK.COM>
References: <MAXPR01MB2688CFCA349F11FAD7B495EB9EEB9@MAXPR01MB2688.INDPRD01.PROD.OUTLOOK.COM> <MAXPR01MB2688DD8FDA61430C16DD584C9EE99@MAXPR01MB2688.INDPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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