Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    7

    Unanswered: Exporting schemas

    I have a db A which has 3 schemas -> X , Y and Z..... Now is it possible to replicate only the schema Z into a new database.....

    What i know is i can prepare DDL of all objects in the schema and then export data and import data in new db.... however since i have 35 tables that will be a tedious task.....

    Any other way out???

    Thanks....

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    You haven't said what version of Oracle you are using. However, a 'one size fits all versions' answer would be to create a database with tablespace/s to match the existing database, then export/import Schema Z.

    Google for exporting a schema & you'll find loads of sites telling what to do.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Sep 2008
    Posts
    7
    version which i am using is
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit

  4. #4
    Join Date
    Dec 2003
    Posts
    1,074
    You want to use Oracle Data Pump:

    http://download-west.oracle.com/docs...p_overview.htm

Posting Permissions

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