Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Unanswered: OEM 10.2.0.0.0 copy from db to another

    Hey Gang, question, is it posible to copy a complete schema one schema to another. For instance, you have a test and a dev instance of the same database. Once the new data, view, table, PL SQL block etc... have been run and you need to move them up the next staging area. IS this posible?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Words matter!
    schema <> instance <> database

    The best tool to transfer a schema is export/import.

    Alternatively just apply the same DDL to every instance to create new objects.
    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 2004
    Posts
    796
    Provided Answers: 1
    Have you looked at the possibility of using Datapump?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    Quote Originally Posted by garrydawkins
    Hey Gang, question, is it posible to copy a complete schema one schema to another. For instance, you have a test and a dev instance of the same database. Once the new data, view, table, PL SQL block etc... have been run and you need to move them up the next staging area. IS this posible?
    You can try data pump or replication
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

  5. #5
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Red face OEM 10.2.0.0.0 copy from db to another

    Which is which, the datapump is a internal utility?

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Datapump is oracles replacement for export * import and is faster, more compact and has more features.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Red face OEM 10.2.0.0.0 copy from db to another

    Which is which, the datapump is a internal utility?

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    please give example of internal utility & external utility.
    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
  •