Data Pump vs EXP/IMP: Difference or Comparison Between Data Pump Expdp/impdp and Conventional EXP/IMP

• Datapump introduced in Oracle 10g whereas conventional exp/imp was used for logical backups in prior versions of oracle 10g. Exp/imp works even in all versions of Oracle.
• Conventional exp/imp can utilize the client machine resource for taking the backups but, the datapump works only in server.

Execute Immediate Command Fails with DBA role: ORA-01031: insufficient privileges

Error Description:

The procedure with execute immediate command is failing with ORA-01031: insufficient privileges. The procedure is trying to create a table and drop the table. The owner of the procedure has DBA role. Still the user cannot create the table or drop the table through execute immediate command. The user is able to create and drop the table using SQL*Plus prompt.

Fix ORA-10636: ROW MOVEMENT is not enabled Table Shrink Command Failed

Error Description:

Table shrink command failed with following error.

SQL> alter table siebel.EIM_ACCNT_UT shrink space compact;

alter table siebel.EIM_ACCNT_UT shrink space compact

*

ERROR at line 1:

ORA-10636: ROW MOVEMENT is not enabled

ORA-10662: Segment has long columns, Table Shrink Command Failed: Workaround

Error Description

‘Alter table tablename shrink space compact’ command failed with following error.

SQL> alter table siebel.EIM_SR_DTL shrink space compact

*

ERROR at line 1:

ORA-10662: Segment has long columns

Problem Description:

Fix Data Pump EXPDP Error ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

Error Description:

Datapump EXPDP export is failed with following error.

ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

Job "SYS"."SYS_EXPORT_TABLE_01" stopped due to fatal error at 03:08:04

Database Recovery from Corrupted, Missing Redo, Archive Log Files Using _ALLOW_RESETLOGS_CORRUPTION, _CORRUPTED_ROLLBACK_SEGMENTS, _minimum_giga_scn and _allow_error_simulation

Recovery Scenario:

This recovery method will help you to recover the database in following situations.

1. If you lose all redo log files for the database. It can be deleted by mistake or disk corruption.
2. If you database recovery needed by redo log group corruption

ORA-01548: active rollback segment, Find out Oracle 10g 11g Active Undo Segments from system datafile

Error Description:

Drop UNDO tablespace command fails with following error.

SQL> drop tablespace UNDOTBS1 including contents and datafiles;

drop tablespace UNDOTBS1 including contents and datafiles

*

ERROR at line 1:

ORA-01548: active rollback segment '_SYSSMU1_2986795754$' found, terminate

dropping tablespace