thanks, i was moving in the same lines you suggested (using OEM) but when i use 'Create like..', a few check constraints originally not in the table are also being created. Therefore< i thought may be there is another easy and correct way.
manjunath

Sorry, I am using 8.0.5