Results 1 to 5 of 5

Thread: Exp DB

  1. #1
    Join Date
    Jul 2004
    Posts
    10

    Unhappy Unanswered: Exp DB

    Hi,

    I am fairly new to Oracle, and am attempting a task which I would have thought should be easy. However, as with most things in Oracle, it has thus far taken hours to try and figure out what to do, to no avail in the end anyway. Rant over.

    I have three Oracle Instances Prod, Test, Dev which are all more-or-less identical in structure. I simply want to take a copy of all of the Prod Instance objects and data, and use these to replace all objects and data of the Dev instance.

    So far I have been attempting to use the Export Utility, but keep running into errors. The truth is I'm not 100% sure this will achieve what I'm trying to do, and have so far tried lots of different things. I won't go into details but I have spent a long time playing around with permissions, granting the EXP_FULL_DATABASE privilege to a user, trying different combinations etc, all to no avail.

    I wold be grateful if someone could advise on the best way of doing this.

    Many thanks

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    how many schemas in the prod db?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jul 2004
    Posts
    10
    Just one schema.

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    i suggest only exporting that 1 schema

    exp username/password@sid owner=production_owner file=production_data.dmp

    then either drop and recreate user in the dev environment or
    write a script to drop all dev's objects

    then import

    imp sys/password file=production_data.dmp fromuser=production_owner touser=dev_owner ignore=Y
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jul 2004
    Posts
    10
    Thanks Mr Duck,
    That seems to have worked.

    Export terminated successfully without any warnings.

    What beautiful words.



    Cheers

Posting Permissions

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