I am anew beginner in Teradata, I tried to run the Mload but accidently I deleted the ET table.
Now I am facing the following error:
TY0805 RDBMS failure, 2583: ET error table is missing for retail.darea during MLoad restart. ======================================================================== = = = Logoff/Disconnect = = = ======================================================================== **** 18:39:37 UTY6215 The restart log table has NOT been dropped. **** 18:39:38 UTY6212 A successful disconnect was made from the RDBMS. **** 18:39:38 UTY2410 Total processor time used = '0.40625 Seconds' . Start : 18:39:36 - THU OCT 21, 2010 . End : 18:39:38 - THU OCT 21, 2010 . Highest return code encountered = '12'.
darea is my table name.
Is there any workaround inorder to start the Mload. I tried to create ET errortable with the following command:
CREATE MULTISET TABLE retail.ET_darea ,FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( ImportSeq BYTEINT FORMAT 'ZZ9' NOT NULL, DMLSeq BYTEINT FORMAT 'ZZ9' NOT NULL, SMTSeq BYTEINT FORMAT 'ZZ9' NOT NULL, ApplySeq BYTEINT FORMAT 'ZZ9' NOT NULL, SourceSeq INTEGER FORMAT '-------------9' NOT NULL, ErrorCode INTEGER FORMAT '-------------9' NOT NULL, ErrorField CHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, HostData VARBYTE(64000) NOT NULL) UNIQUE PRIMARY INDEX ( ImportSeq ,DMLSeq ,SMTSeq ,ApplySeq ,SourceSeq );
But still I get the same error.
Before I load I will delete the logtable and starts loading.