Pivotal Knowledge Base

Follow

HowTo - Install / Uninstall Oracle Functions

Goal

How to install and uninstall  Oracle functions in Pivotal Greenplum(GPDB)

Solution 

Users can install Oracle functions using the following SQL script

psql -d <database-name> -f $GPHOME/share/postgresql/contrib/orafunc.sql

The following is the uninstall script

psql -d <database-name> -f $GPHOME/share/postgresql/contrib/uninstall_orafunc.sql

Comments

Powered by Zendesk