IMP-00058: ORACLE error 1653 encountered ORA-01653: unable to extend table
Hello All,
I have my database on AIX server. In which i am importing dump file of around 3.5GB.
Initially i tried to create 4GB table space with following command:
CREATE TABLESPACE TBS_TEST
DATAFILE '/app/oracle/oradata/TBS_TEST.dbf' SIZE 4000M
AUTOEXTEND ON NEXT 500K MAXSIZE 6000M
ONLINE EXTENT MANAGEMENT LOCAL;
After running this it gave me below error:
ERROR at line 1:
ORA-01119: error in creating database file
'/app/oracle/oradata/TBS_TEST.dbf'
ORA-27044: unable to write the header block of file
IBM AIX RISC System/6000 Error: 27: File too large Additional information: 4
while i am able to create tablespace with 2GB.
we have given ulimit oracle user then to this issue isn't resolve.
Now after creating tablespace with 2GB and keeping its maxsize to 6000MB i am trying to import my dump file in which one transaction table which is having one BLOB column in it and it contains 17 lakh records.
when this table is importing after 6 lakh records it gave below error:
IMP-00058: ORACLE error 1653 encountered ORA-01653: unable to extend table
and my tablespace is also full and not even autoextending.
Kindly suggest some solution.
Thanks