Results 1 to 12 of 12
  1. #1
    Join Date
    Nov 2004
    Posts
    11

    Question Unanswered: How to transfer data(tables) from one database to another database?

    Hello

    I have to transfer tables from one machine to another machine. I am using toad & also oracle.

    Looking forward for an early reply

    Thanks

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    NOTE: Please disregard the label "Senior Member".

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    NOTE: Please disregard the label "Senior Member".

  4. #4
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    My URL is for 9i, other DB versions have the same functionality.

    [Duplicate posts are because the forums server is having a break down.]
    Last edited by Todd Barkus; 12-21-04 at 12:37.
    NOTE: Please disregard the label "Senior Member".

  5. #5
    Join Date
    Mar 2004
    Posts
    370
    See this link , also you could use "copy" command in sqlplus but it seems not to be accepted by everybody.
    http://www.dbazine.com/foot2.shtml

  6. #6
    Join Date
    Nov 2004
    Posts
    11

    Smile How to transfer data(tables) from one database to another database?

    I implemeted, it worked.

    Thanks.

    Merry Xmas.

  7. #7
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Holy Frijoles!! I have been working too hard. Copy looks like a great technique.
    NOTE: Please disregard the label "Senior Member".

  8. #8
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by Todd Barkus
    Holy Frijoles!! I have been working too hard. Copy looks like a great technique.
    The down side with copy is that it won't move all types of data. It can only handle CHAR, DATE, LONG, NUMBER, and VARCHAR2. Any other data type will fail.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  9. #9
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Great Guacamole!! It looks like another case of RTM (read the manual)!!
    NOTE: Please disregard the label "Senior Member".

  10. #10
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Oracle have been saying for a while that SQL*Plus COPY is only provided for backward compatibility (although it can still be pretty useful), and recommending INSERT...SELECT or exp/imp.

  11. #11
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by WilliamR
    Oracle have been saying for a while that SQL*Plus COPY is only provided for backward compatibility (although it can still be pretty useful), and recommending INSERT...SELECT or exp/imp.
    I couldn't agree more. When I need to copy a table from database to database, I setup a database link and then do a simple select to move the data over.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  12. #12
    Join Date
    Aug 2004
    Posts
    18

    move oracle data and support most types (blob, etc)

    Quote Originally Posted by beilstwh
    The down side with copy is that it won't move all types of data. It can only handle CHAR, DATE, LONG, NUMBER, and VARCHAR2. Any other data type will fail.
    try fastreader www.wisdomforce.com

    fastreader unloads into flat file veryquickly and generates scripts for sqlldr.
    supports most of data types, and Oracle starting from version 8 I beleive, on all plattforms

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •