CODEWITHSUNDEEP
oracle-databaseoracle11g
WellingtonD
WellingtonD

Reputation: 165

ORA-39171 ORA-01659 impdp

I'm trying to restore my Oracle backup version 11.2.0.1 to another server version 11.2.0.4.

When I run the impdp, the ORA-39171 and ORA-01659 erros are shown.

impdp hosp/xxxx file=HOSP3001.DMP logfile=loghosp3001.dmp version=latest schemas=HOSP

In the .dmp file I have the following TABLESPACES and DATAFILES:

DATAFILE                                          | TABLESPACE

/u01/app/oracle/product/11.2.0/db_1/dbs/HOSP      | HOSP
/u01/app/oracle/product/11.2.0/db_1/dbs/HOSPDATA  | HOSPDATA
/u01/app/oracle/product/11.2.0/db_1/dbs/HOSPDATA2 | HOSPDATA
/u01/app/oracle/product/11.2.0/db_1/dbs/HOSPDATA3 | HOSPDATA

I have created in the new server the follwing TABLESPACES and DATAFILES. 

CREATE TABLESPACE HOSP DATAFILE 'HOSP' SIZE 1024M ;
ALTER DATABASE DATAFILE 'HOSP' RESIZE 1024M ;
ALTER DATABASE DATAFILE 'HOSP' AUTOEXTEND ON MAXSIZE UNLIMITED ;

CREATE TABLESPACE HOSPDATA DATAFILE 'HOSPDATA' SIZE 1024M ;
ALTER DATABASE DATAFILE 'HOSPDATA' RESIZE 1024M ;
ALTER DATABASE DATAFILE 'HOSPDATA' AUTOEXTEND ON MAXSIZE UNLIMITED ;

In this new scenario I intend to keep just one DATAFILE for the TABLESPACE "HOSPDATA".

Upvotes: 1

Views: 2969

Answers (3)

sure ruan
sure ruan

Reputation: 27

you can use impdp with option "transform=segment_attributes:n"

Upvotes: 0

Thomas Mwania
Thomas Mwania

Reputation: 405

ORA- 39171:is usually caused by a non expandable tablespace running out of space leading to stall of the Data Pump job. Adding datafiles to the tablespace running out of space will usually solve the problem.

ORA-01659: Explains the actual cause of ORA- 39171. In this specific case, oracle failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created. Again, the solution will still be adding a datafile to that tablespace.

If you still want to import the data into a single DATAFILE, oracle provides a remapping utility as follows: REMAP_DATAFILE=source_datafile:target_datafile

Upvotes: 0

Sergiu Velescu
Sergiu Velescu

Reputation: 514

Check your alert.log, most probably you will find the answer there. It looks like you do not have free space in the tablespace.

Upvotes: 2

Related Questions