Friday, January 22, 2016

impdp hang statement suspended, wait error to be cleared




space issue or add more datafiles

select file_name,tablespace_name,bytes/1024/1024 "Size MB",status,autoextensible,maxbytes/1024/1024 "MaxSize MB" from dba_data_files;
select file_name,tablespace_name,bytes/1024/1024 "Size MB",status,autoextensible,maxbytes/1024/1024 "MaxSize MB" from dba_temp_files

No comments:

Post a Comment

Followers