Data Warehousing Community Forum
February 08, 2012, 11:49:14 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Unable to relealse Mload  (Read 1629 times)
Allegra
DW Apprentice
**

Reputation: +17/-0
Offline Offline

Posts: 75



View Profile
« on: September 08, 2010, 12:29:58 pm »
Guys -

I was unable to release mload on a table. Am getting "operation can't be completed" error.

Source of this error is as follows -
One of the session got failed with the below error -
Quote
UTY0805 RDBMS failure, 3803: Table 'WT_TAB_NAME' already exists.

So I have executed below mentioned drop and release statements -
Quote
DROP TABLE DB_NAME.ET_TAB_NAME;
DROP TABLE DB_NAME.UV_TAB_NAME;
DROP TABLE DB_NAME.WT_TAB_NAME;

release mload DB_NAME.TAB_NAME;

Please advise...
Logged
@llegr@
what do you call an Ant with an AK47 ?
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: September 14, 2010, 12:49:57 am »
If the mload process is in Acquisition phase, then use this syntax -
 
Code:
release mload DB_NAME.TAB_NAME in apply;
Logged
Sipra
Founder

www.dwforum.net
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: