I'm not sure why I am getting this error.
sql> insert into a_records_bkup select * from a_records;
insert into a_records_bkup select * from a_records
*
ERROR at line 1:
ORA-01653: unable to extend table APP.A_RECORDS_BKUP by 8192 in tablespace IMR_A_DATA
Tablespace IMR_A_DATA has no data before the insert statement is run.
CREATE TABLESPACE imr_a_data
DATAFILE '/du06/oracle/oradata/imr1/imr_a_records_data01.dbf'
SIZE 2G
REUSE
AUTOEXTEND ON NEXT 4096K
MAXSIZE UNLIMITED
/
There is plenty of free space on the NFS share:
FileSystem Size Used Avail Use % Mounted on
--------------- ---- ---- ---- ----- ----------
netappdb:/du09 1.1T 89G 967G 9% /du06
Here is the data I am inserting from:
TABLE_NAME TABLESPACE_NAME NUM_ROWS SIZE_MB PCT_FREE COMPRESS LOG
---------------- ----------------- ---------- ---------- ---------- -------- ---
A_RECORDS IMR_A_DATA 205345290 49323.9297 10 DISABLED YES
Any suggestions on resolving this issue?