ORA-01653 Unable to Extend Table AGILE.A_DW_TXN_LOG BY 128 in Tablespace AGILE_DATA3
1
vote
1
answer
956
views
I am trying to import an oracle database from a dump file. While importing I am getting
>ORA-01653 Unable to Extend Table AGILE.A_DW_TXN_LOG BY 128 in Tablespace AGILE_DATA3`.
I have tried to fetch the information about the tablespace with this query and I am not able to understand what these columns hold information about.
SELECT * FROM DBA_DATA_FILES WHERE Tablespace_name = 'AGILE_DATA3';
|FILE_NAME |FILE_ID|TABLESPACE_NAME|BYTES |BLOCKS |STATUS |RELATIVE_FNO|AUTOEXTENSIBLE|MAXBYTES |MAXBLOCKS|INCREMENT_BY|USER_BYTES |USER_BLOCKS|ONLINE_STATUS|
|-------------------------------------------|-------|---------------|-----------|-------|---------|------------|--------------|-----------|---------|------------|-----------|-----------|-------------|
|D:\APP\ORADATA\AG934\AGILE_DATA301AG934.ORA| 11|AGILE_DATA3 |26791116800|3270400|AVAILABLE| 11|YES |34359721984| 4194302| 1280|26789019648| 3270144|ONLINE |
I looked up at this link but as I look into my table I find Auto Extension already enabled. What is it I am not doing correctly here ? I am using
data pump
utility available in sql developer to import the dump file.
Also I hope that when we import the dump file it actually overwrites all of the information already present on the database. Is that correct ?
Asked by Muhammad Asim
Jun 25, 2020, 01:40 PM
Last activity: Jul 29, 2025, 12:46 PM
Last activity: Jul 29, 2025, 12:46 PM