- Oracle Data Pump is a new feature of Oracle Database 10 g that provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
- DBMS_DATAPUMP package provides a server-side infrastructure for fast data and metadata movement. expdp and impdp is used to import/export activites.
- It vastly improved performance and greatly enhanced functionality, such as restartability, flexible object selection, and better monitoring and control of export and import jobs.
- Data Pump is server-based, rather than client-based. Dump files, log files, and SQL files are accessed relative to server-based directory paths, so that appropriate file security can be enforced.
- Data Pump requires you to specify directory paths as directory objects. A directory object maps a name to a directory name on the file system.
- Before you can run Data Pump Export or Data Pump Import, a directory object must be created by a DBA or by any user with CREATE ANY DIRECTORY privilege.
Tips and good resources for all.. Oracle, Big data, Hadoop, Unix, Linux
Wednesday, January 19, 2011
What is Oracle Data Pump (impdp and expdp)?
Friday, December 31, 2010
What is autonomous transaction in Oracle?
- An autonomous transaction is an independent transaction that is initiated by another transaction (the parent transaction).
- An autonomous transaction can modify data and commit or rollback independent of the state of the parent transaction.
- The autonomous transaction must commit or roll back before the autonomous transaction is ended and the parent transaction continues.
- An autonomous transactions is available from Oracle 8i.
- An autonomous transaction is defined in the declaration of a pl/sql block. This can be an anonymous block, function, procedure, object method or trigger.
- This is done by adding the statement 'PRAGMA AUTONOMOUS_TRANSACTION;' anywhere in the declaration block.
- Autonomous transactions can be used for logging in the database independent of the rollback/commit of the parent transaction.
CREATE OR REPLACE PROCEDURE test
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
insert ....
commit;
END;
Subscribe to:
Posts (Atom)