My Oracle Support Banner

Import Failed With Error ORA-1741 When Creating Partitioned Table (Doc ID 337849.1)

Last updated on APRIL 03, 2020

Applies to:

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

Symptoms

During import you get the following errors:

IMP-00017: following statement failed with ORACLE error 1741,
ORA-01741: illegal zero-length identifier,
IMP-00057: Warning: Dump file may not contain data of all partitions of this table
IMP-00055: Warning: partition or subpartition "<TABLE_NAME>":"<PARTITION/SUBPARTITION_NAME>" not found in export file


when creating a partition table with organization index (IOT).

The create table statement in the import log references a "" (NULL) value for the default tablespace of the table.

"CREATE TABLE "<TABLE_NAME>" ("<LIST_OF_COLUMNS>", 
CONSTRAINT "<PK_CONSTRAINT_NAME>" PRIMARY KEY ("<LIST_OF_PK_COLUMNS>"
) ENABLE ) ORGANIZATION INDEX  PCTFREE 10 INITRANS 2 MAXTRANS 255 STO"
"RAGE(INITIAL 13107200 NEXT 13107200 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTI"
"NCREASE 0) TABLESPACE "" NOLOGGING NOCOMPRESS PCTTHRESHOLD 50 PARTITION BY "

Changes

At the time the partition table was created the instance was pre-817.

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.