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

Thread: moving all the data from a 9i to a 9i

  1. 01-21-2003, 10:27 AM #1
    ter055
    ter055 is offline Junior Member
    Join Date
    Jan 2003
    Posts
    33

    moving all the data from a 9i to a 9i

    Hello,
    who knows which is the best method to get data (not the structure) from a DB to another one, both 9i. Only some fields have a different length (in the original number(5) in the target number(9)). Any Oracle Enterprise application for that?
    Thanks, ter
    Last edited by ter055; 01-21-2003 at 10:37 AM.
    Reply With Quote Reply With Quote
  2. 01-21-2003, 10:32 AM #2
    sgodbole
    sgodbole is offline Junior Member
    Join Date
    Jan 2003
    Posts
    78
    If the table's data size is not big, then you can export from source database and import into target with ignore = y. Another option is to use sql/plus copy command.
    HTH.
    Shripad Godbole
    OCP DBA (8,8i,9i)

    "Let's document it and call it a feature."
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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