Archives of the TeradataForum

Message Posted: Tue, 17 Jul 2012 @ 15:21:43 GMT


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

Subj:		Releasing mload pending from a table

From:		JAMES PARK

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.

James Park