Archives of the TeradataForum
Message Posted: Mon, 11 Mar 2002 @ 20:16:04 GMT
| 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.