/* Formatted on 6/4/2014 2:09:39 PM (QP5 v5.115.810.9015) */
SELECT osuser, serial#, sql_text
FROM v$session, v$sql
WHERE v$session.sql_address = v$sql.address
AND v$session.status = 'ACTIVE';
SELECT osuser, serial#, sql_text
FROM v$session, v$sql
WHERE v$session.sql_address = v$sql.address
AND v$session.status = 'ACTIVE';
virtualnuggets offering oracle dba online training,corporate training services.
ReplyDeleteData Pump enables you to specify whether a job should move a subset of data and metadata. This is done using data filters and metadata filters, which are implemented through Export and Import parameters.
Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be moved to another system and loaded by the Data Pump Import utility.