Check character set of Database which export dump file has been already taken.
You check the character set with below query.
select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_LANGUAGE');
Also check the character set of DB which needs to be imported.
Check whether the characterset conversion is possible or not.
Sometimes a corrupted dumpfile cause this error.Suppose if you are trying to import using IMP from a EXPDP(Data pump Export)dumpfile Cause this error .
Thursday, May 31, 2012
Wednesday, May 30, 2012
ora-04030 out of process memory while trying to allocate 'N' bytes.
Delete all the save points from workspace.We can see the save points from WMSYS.WM$WORKSPACE_SAVEPOINTS_TABLE.Use below query to remove save points from worskspace .
workspace IN VARCHAR2,
savepoint_name IN VARCHAR2,
compress_view_wo_overwrite IN BOOLEAN DEFAULT FALSE,
auto_commit IN BOOLEAN DEFAULT TRUE,
commit_in_batches IN BOOLEAN DEFAULT FALSE,
batch_size IN VARCHAR2 DEFAULT 'PRIMARY_KEY_RANGE');
After the successful removal of save points,You can remove workspace simply by
Thursday, May 10, 2012
You can forcefully Disable Version tables that have already modified in non Live Workspace in Oracle.But all the changes made by the non Live workspace will be neglected.
SQL> EXEC DBMS_WM.DISABLEVERSIONING('TABLE_NAME',TRUE);