Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    16

    Unanswered: data exp/imp from particular tables to particular tables

    hi.
    i want to extract only the record from the tables in my database and import them to a different database where i have similar tables(there may or maynot be some extra columns) is there any way to do this i know about spool but its just like a print out i dnt know wheter its usefull for importing into another database
    a bit urgent..
    Thanx in Advance
    "TALK SENSE TO FOOL. HE CALLS U FOOLISH"

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Staging

    You would need to import into a "staging" table and code an sql to populate the target table.
    .
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    can you make a database link between the two databases or use the sqlplus copy command. It might be as simple as doing an insert.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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