Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2004
    Location
    Salem, Oregon
    Posts
    19

    Unanswered: Full database Export and Import

    I am trying to export a full database from one platform and Import it on to another. They are both using the same version of Oracle on the same version of linux. The one I am exporting from has two databases on it dev and test. The other machine has a database called devtest. I want to import the dev to devtest. I cannot find any docs on what has to be set up to do this. Do I need to set up the tablespaces or let the import do this? Does this cause any problems with the systems tablespaces, Aux and other tablespaces already on it . The exported tablespaces are on /u02/oradata/dev the other is /u02/oradata/devtest.
    Thanks for your help

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    take a look into the utilities manual

    imp has the option fromuser= touser= option

  3. #3
    Join Date
    Apr 2004
    Location
    Salem, Oregon
    Posts
    19
    I probably should have said this is using DataPumps export and I see nothing in the utilites manual about
    imp has the option fromuser= touser= option.
    I am sure someone has exported a database to another Instance before...

  4. #4
    Join Date
    Oct 2004
    Posts
    145
    If you let import create the tablespace it will "attempt" to restore it into same location.

    If you create the tablespace prior to doing a full import, you can perform complete migration from one environment to another (specially on same version).

    Full import will bring in all userid/passwords, all objects even owned by system, etc.

    If you are going to use fromuser/touser method, you must pre-create the users in the new environments and must examine which schemas own objects, etc.

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I usually :

    1. Create the database on the other machine (as you have done)
    2. Create the tablespaces on the other machine to match my existing DB
    3. Create the User(s) that I am going to pull the data into
    4. Export the Schemas from the "live" db and import them into the New db.

    .... If you have a FULL db export, then you can create ALL schemas on
    the new db and import the schemas one at a time with fromuser= touser=

    As stated above, if you don't have the tablespaces already created on the
    new database, the import will attempt to create those tablespaces in the
    same directory structure that they are in on the "live" machine ...

    HTH
    Gregg

  6. #6
    Join Date
    Apr 2004
    Location
    Salem, Oregon
    Posts
    19
    where can I find this

    "imp has the option fromuser= touser= option"
    Documentation it is not in my Utilites manual with Oracle 10g.

    And what happens to the system, temp, sysaux, and redo tablespaces that are already there when you import the new database?

  7. #7
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I've not worked with 10g yet but here is some documentation on it ...
    http://download-west.oracle.com/docs...htm#sthref2519

    ... This is from the 10g admin guide ...

    HTH
    Gregg

  8. #8
    Join Date
    Apr 2004
    Location
    Salem, Oregon
    Posts
    19
    Thanks for all the Good Information.
    I will give it a try.
    :>)

  9. #9
    Join Date
    Apr 2004
    Location
    Salem, Oregon
    Posts
    19
    Another related question.
    How do you export a database at a earlier version level of export for someone that cant read your export because they are at a different level?
    We have export V10.01.00 they are at V9.02.00

  10. #10
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Can't go backwards ... At least I don't believe so ... The sys and system
    schema structures are entirely different ...

    You might try (from 9i machine) export the 10g user_schema
    from (9i machine) import the user_schema ...

    I just don't believe that you will be able to do it, but it won't hurt but
    once ...

    HTH
    Gregg

Posting Permissions

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