Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)

From: Chetan Kosanam <chetan(dot)kosanam(at)tcs(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: Harinarayana Kadiyala <harinarayana(dot)kadiyala(at)tcs(dot)com>, Md Rakibuddin <md(dot)rakibuddin(at)tcs(dot)com>, SAI CHANDANA CHAMALA <sc(dot)chamala(at)tcs(dot)com>, "Sandu Sai Prasad" <saiprasad(dot)sandu(at)tcs(dot)com>, UPPALA NIKHITA <venkata(dot)uppala(at)tcs(dot)com>, Sai Pratyusha Gantimahapatruni <sai(dot)gantimahapatruni(at)tcs(dot)com>, Mohammed Imran <imran(dot)mohammed(at)tcs(dot)com>, Kotha Parvathi <kotha(dot)parvathi(at)tcs(dot)com>, Uma Puttappa <uma(dot)puttappa(at)tcs(dot)com>, Veerraju Yeluduti <veerraju(dot)y(at)tcs(dot)com>
Subject: Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)
Date: 2022-12-23 09:37:34
Message-ID: MAXPR01MB2688DD8FDA61430C16DD584C9EE99@MAXPR01MB2688.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)kosanam(at)tcs(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2022-12-23 11:20:07 Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...
Previous Message Takamichi Osumi (Fujitsu) 2022-12-23 06:03:22 RE: Support logical replication of DDLs