0 pts.
 Migration Problem
SQL
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...

Software/Hardware used:
ASKED: July 25, 2007  8:50 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _