Pivotal Knowledge Base

Follow

How to Install and Uninstall Oracle Functions

Environment

Pivotal Greenplum Database (GPDB) all versions

Purpose

This article describes how to install and uninstall  Oracle functions in Pivotal Greenplum Database (GPDB).

Procedure 

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