-
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
kavitha
-
no, u can migrate this type of data using Export/Import utility only.
Manoj Ghosh
-
mig
HII, MANOJ my datatypes are different and table name different.
is it exp/imp useful?
thanks
kavitha
kavitha
-
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)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|