My Oracle Support Banner

ORA-1537 ORA-3280 Reported For Create Tablespace When Runing DataPump Import (Doc ID 1351252.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Full DataPump import shows the errors below while creating the tablespaces:

ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01537: cannot add file '<PATH>/redo04.log' - file already part of database
SQL statement: CREATE TABLESPACE "<TABLESPACE_NAME>" DATAFILE '<PATH>/redo04.log' SIZE 106496 AUTOEXTEND ON NEXT 65536 MAXSIZE 32767M,'<PATH>/redo02.log' SIZE 106496 AUTOEXTEND ON NEXT  65536 MAXSIZE 32767M, SIZE 106496 AUTOEXTEND ON NEXT 65536 MAXSIZE 32767M;


or:

ORA-39083: Object type TABLESPACE failed to create with error:
ORA-03280: invalid DATAFILE filename specified
Failing sql is:
CREATE TABLESPACE "<TABLESPACE_NAME>" DATAFILE
'<PATH>/redo08_3.log' SIZE 10485760,
'<PATH>/redo08_2.log' SIZE 10485760,
'<PATH>/redo08_1.log' SIZE 10485760,
'' SIZE 10485760,


Checking the tablespace definition with dbms_metadata.get_ddl in the source database:

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.