Procedure

[kavithared]

HIII, I heard to migrate data one db to another db where table structure and their datatypes are different.we can do by using stored procedure with cursor.
Ex---scott.abc table id char(10)
name char(20)
My olddb name A

my newdb Name B
xyz.bc table eid char(20)
address varchar2(30)
name char(20)

Now migration of data from abc to bc table by using procedure and cursor.
IS it possible?
If yes any one can write procedure for above table.
thanks
kavitha

[manojgh]

no, u can migrate this type of data using Export/Import utility only.

[kavithared]

HII, MANOJ my datatypes are different and table name different.
is it exp/imp useful?
thanks
kavitha

[ales]

Originally posted by manojgh
no, u can migrate this type of data using Export/Import utility only.

Why?

(Perhaps would be better to continue on the similar thread in Admin forum)