Archives of the TeradataForum
Message Posted: Tue, 17 Jul 2012 @ 15:21:43 GMT
TD 13 on Window
I was copying one database with its all tables and data to another database.
I copied all but 2 because these 2 tables are in mload pending. Operations were not allowed because these tables were in mload pending.
Each table has 3 million and 5 million of rows. I attempted to remove mload pending with RELEASE MLOAD DATABASENAME.TABLENAME; but this command ran forever and I had to abort.
It seems that without removing mload pending I can't copy these tables from one database to another. How can I remove mload pending? Why does this command take so long?
Your help is always appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|