I'm having a dataset A contains 10 crores of records and dataset B contains 1crore records. Both datasets having same properties like variable name,format...
I have written code like this
proc append base=libname.A data=libname.B force;
run;
After executing above code getting error aftersome time
ERROR ERROR ERROR: ORACLE EXECUTE ERROR :ORA-01653 unable to extend the table tablename by 8129 in table space with the occurence of above error, the error limit of 1 set by ERRLIMIT= option has been Rollback has been issued(AnyRows processed after the last COMMIT are lost)
Please help me out. its bit urgent.
Many many many thanks..