DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Procedure

  1. #1
    Join Date
    May 2002
    Posts
    232
    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

  2. #2
    Join Date
    Jun 2002
    Posts
    13
    no, u can migrate this type of data using Export/Import utility only.
    Manoj Ghosh

  3. #3
    Join Date
    May 2002
    Posts
    232

    mig

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

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    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
  •  


Click Here to Expand Forum to Full Width