Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Monthly Archives: February 2009
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.
Deleting Duplicate rows.
There are a number of ways in which you can deleteduplicate rows froma table. Here’s some examples.
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 automated, DBMS_DATAPUMP, expdp, EXPORT~JOB, IMPDP
Comments Off
DBMS_ASSERT
DBMS_ASSERT. Interesting functions here, which can assist you in confirming a schema or object prior to execution.