Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2007
    Posts
    1

    Unanswered: transfering oracle tables

    how can i transfer/export Oracle 10g xe database tables under different user names from the Oracle database 10g xe installed in one system to Oracle database 10g xe installed in another system. the two system are not connected in any way.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    by using the export 9exp) & import (imp) utilities.
    They are documented in the Utilities Manual found at http://tahiti.oracle.com
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

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

    Talking



    Or if there are just a few tables, use the COPY command.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >the two system are not connected in any way
    Assuming the above is true, please elaborate on EXACTLY how to use the COPY command?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The copy command is very limited and it is unable to transfer things like clob, blob, long, timestamps and any other datatype introduced since version 8. Use export/import and the from-user to user commands of import.
    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
  •