Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2009
    Posts
    56

    Exclamation Unanswered: copy the data from one schema to another with in a single database

    Hello FRIENDS,

    I got one user with schema name tpemgr_e3 and another user with schema tpemgr both but in a single database.

    both the schemas are having same tables.

    i need to copy data from one schema tpemgr_e3 to tpemgr.

    let me know how to copy the data.

    appreciate your help.

    thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Export source schema and import it into the target schema. Don't forget to include IGNORE=Y (or drop all objects in target schema before import).

  3. #3
    Join Date
    Nov 2009
    Posts
    56
    Thanks for your reply.

    I don't want to use export or import .

    without using export / import can we do copy data from one schema to another.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Sure, why not. Grant required privileges and INSERT INTO target_table SELECT * FROM source_table. Repeat the above as many times as there are tables in those schemas. Don't forget to create scripts for copying other objects (stored procedures, packages, functions, triggers, ...). To do that, research use of DBMS_METADATA.

    However, why do you not want to use export/import? It looks like you'd want to dig a deep hole, but don't want to use a shovel and would like to use spoon instead. Possible, but with much more pain. So: why not export/import as it is designed to move data around?

  5. #5
    Join Date
    Nov 2009
    Posts
    56
    Can u please give me an example how i use import/export strategy.

    appreciate your help

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    exp help=yes
    imp help=yes

    Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation

    Read The Fine Manual - Utilities Manual
    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.

Posting Permissions

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