Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 11 Mar 2002 @ 20:16:04 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Table being fastloaded
 
From:   Geoffrey Rommel

  Is there an indicator in Teradata to identify tables that are being fastloaded? We have some users who start a fastload, it fails, and they don't drop the table or complete the load. When we archive the database, the archive utility gives a warning about these tables. I'd like to be able to find and drop them before the archive.  



We just went through this with a big migration. You need to delete the rows from sysadmin.fastlog. Then you should be able to proceed with your archive.

You could also run through sysadmin.fastlog, build tiny FastLoad scripts for each table (just "begin loading" and "end loading" for each one), and run all the scripts, but I think deleting the rows is sufficient.


--wgr



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023