GreenplumDBA.com website will no longer be available on public domain. Email us at gpdba@greenplumdba.com for further details.  Become a registered member of DBAref.com and you will get full access to all of our blog posts, white papers, Greenplum Database eBooks and much more.

Greenplum DBA Quick Reference

  • Dynamic UNIX script to change the owner of tables in Greenplum -- Change owner of all tables of a given schemafor tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" sachi` ; do  psql -c "alter table $tbl ...
    Posted Oct 26, 2014, 6:34 AM by Sachchida Ojha
Showing posts 1 - 1 of 13. View more »
  • Public Yum Server The Oracle public yum server offers a free and convenient way to install the latest Oracle Linux packages as well as packages from the Oracle VM installation media via a ...
    Posted Apr 22, 2013, 8:43 AM by Sachchida Ojha
  • Oracle external table just like external table in Greenplum In the Greenplum database, we use external table combined with gpfdist to read the data from a  csv file located in in a directory and then then load that data ...
    Posted Feb 23, 2013, 5:08 PM by Sachchida Ojha
  • RESUMABLE SPACE ALLOCATION Oracle database provides a way to suspend long-running operations in the event of space allocation failure. Once the DBA is notified and space issue has been corrected, the long ...
    Posted Feb 4, 2012, 12:01 AM by Sachchida Ojha
Showing posts 1 - 3 of 19. View more »
  • Unix Command Reference for Oracle and PostgreSQL DBA's
  • Install flash plugin firefox - RHEL/Fedora 32bits surpm -ivh http://linuxdownload.adobe.com/adobe-release/adobe-release-i386-1.0-1.noarch.rpmrpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-adobe-linuxyum ...
    Posted May 22, 2013, 9:11 AM by Sachchida Ojha
  • Installing Open Office Suite in RHEL 6 Download open office using linkhttp://www.openoffice.org/download/After your download completes, Open Terminal and Execute the following… # tar xzf OOo_3.3.0_Linux_x86_install-rpm ...
    Posted Apr 22, 2013, 1:55 PM by Sachchida Ojha
Showing posts 1 - 2 of 11. View more »
  • Schema Check sum report set serveroutput onset feedback offset verify offset linesize 10000create or replace type chksumType as VARRAY(3000) of NUMBER;/declare  cursor c0 is    select OWNER, TABLE_NAME ...
    Posted Feb 22, 2013, 2:49 PM by Sachchida Ojha
  • User resource usage SELECT   DECODE(ses.username, NULL, 'SYS', ses.username) username,         TO_CHAR(ses.SID) SID, sn.NAME, sest.VALUE, ins.instance_name,         DECODE(ses.username, NULL, 'SYS', ses.username) || TO_CHAR ...
    Posted Sep 27, 2010, 6:38 AM by Sachchida Ojha
Showing posts 1 - 2 of 10. View more »
  • Configuring PostgreSQL on ORHEL6.1 -bash-4.1$ initdb -D /var/lib/pgsql/dataThe files belonging to this database system will be owned by user "postgres".This user must also own the server process ...
    Posted Apr 22, 2013, 5:47 AM by Sachchida Ojha
  • SECURITY DEFINER or AUTHID CURRENT USER I've just come to minor notice: PostgreSQL defaults to executing procedures with current user rights, Oracle - with definer's rights. It was rather interesting.Let's say we have ...
    Posted Apr 3, 2013, 5:54 PM by Sachchida Ojha
Showing posts 1 - 2 of 20. View more »

Oracle RMAN - Tips and Tricks

  • Flash Recovery Area The Flash R ecovery Area: The flash recovery area (FRA) is not a requirement for using RMAN, but it should be. New in 10g, the FRA is a specific location ...
    Posted Jul 13, 2011, 9:28 AM by Sachchida Ojha
  • Auxiliary Database The auxiliary database refers to the instance that will become host to restored files from the target database in the event of a tablespace point-in-time recovery (TSPITR), a ...
    Posted Jul 12, 2011, 2:08 PM by Sachchida Ojha
  • The RMAN Server Processes RMAN makes a client connection to the target database, and two server processes are spawned. The primary process is used to make calls to packages in the SYS schema in ...
    Posted Jul 12, 2011, 1:55 PM by Sachchida Ojha
Showing posts 1 - 3 of 8. View more »