Monthly Archives: February 2009

Netezza Document

Posted in Netezza | Tagged | Comments Off

Using OPatch

OPatch is installed in it’s own directory under $ORACLE_HOME called OPatch. It does not get added to your $PATH variable and you need to be in the OPatch directory, or add it to execute.

Posted in Oracle | Tagged | Comments Off

Deleting Duplicate rows.

There are a number of ways in which you can deleteduplicate rows froma table. Here’s some examples.

Posted in Configuration., Oracle | Tagged , , | Comments Off

dbms_datapump 10g

DBMS_DATAPUMP The DBMS_DATAPUMP package is used to move all, or part of, a database between databases, including both data and metadata, or for backups.

Posted in datapump, Import/Export, Oracle | Tagged , , , , | Comments Off

DBMS_ASSERT

DBMS_ASSERT. Interesting functions here, which can assist you in confirming a schema or object prior to execution.

Posted in Oracle, Packages | Tagged , , | Comments Off