ERRORS ORA-39150 AND ORA-08186 DURING DATAPUMP IMPORT WHEN USING FLASHBACK_TIME OPTION
SYMPTOMS When attempting to perform a datapump import with the FLASHBACK_TIME option, the following errors occur ORA-39001: invalid argument value ORA-39150: bad flashback time ORA-08186: invalid timestamp specified For instance, the datapump command that was issued oracle@s001dev ~: impdp system/pwd NETWORK_LINK=MERIDB2_TOMSKPROD FLASHBACK_TIME=\”TO_TIMESTAMP\(TO_CHAR\(SYSDATE,\’YYYY-MM-DD HH24:MI:SS\’\),\’YYYY-MM-DD HH24:MI:SS\’\)\” schemas=TOMSKPROD…
ORA-06512, ORA-39127, ORA-01031, ORA-39126, ORA-06502 WHEN IMPORTING FROM A DATABASE WITH THE DATABASE VAULT ENABLED
SYMPTOMS A datapump import performing through a database link fails when the Database Vault is enabled on a source database. The datapump import fails with the following error stack impdp system/password schemas=XXCMD NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=XXCMD_refresh_07SEP2020.import.log EXCLUDE=statistics … Processing object type SCHEMA_EXPORT/VIEW/TRIGGER ORA-39127: unexpected error…
ORA-31671: Worker process DW00 had an unhandled exception.
ISSUE During a datapump import you got the error like the following impdp system/password schemas=XXCDB NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=your_logfile.log … Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name “DW00” prematurely terminated ORA-31671: Worker process DW00…
ORA-1555: SNAPSHOT TOO OLD DUE TO CORRUPTED LOBS
QUESTIONS During schema(s) export or querying a table containing a clob column I recieve the following error ORA-01555: snapshot too old: rollback segment number with name “” too small SOLUTION Usually the ORA-01555 error is related either to the undo retention and the…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (69)
- Account (2)
- AWR (4)
- Database Errors (6)
- Database Performance (10)
- Datapump (4)
- Enterprise Manager (25)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (3)
- High IO Load (4)
- Historical Session Information (3)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Tablespaces (1)
- Temporary Tablespace (2)