I am migrating an Oracle 9i database to a new Oracle 9i database. My problem is that migration of two tables is taking very long. one takes 8 hours and the other takes 4 hours. The reason i can think of is that these two table have clob fields which are being migrated as varchar2 in the new schems. to accomplish this i am copying the clob field from the old database to a temp table in new schema and then to the actual table. Can anyone help me to make this migration faster...its really urgent...
July 25, 2007 8:50 PM