DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: EXP/IMP ?????

  1. #11
    Join Date
    Nov 2000
    I am sorry I forget to add that my database has Designer
    repository. I will be moving this repository in my 8.1.6 database. do I have to do something different for this ???

    thanks all for your reponses

    [Edited by ocpdude on 11-24-2000 at 01:36 PM]

  2. #12
    Join Date
    Nov 2000

    I think just a regular import/export will work. However, I think designer comes with a shortcut that passes all correct parameters to export/import.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #13
    Join Date
    Nov 2000

    in my analysis, there would be no problem with that since the REPOSITORY created by the DESIGNER will also be recreated since the owner of the said repository(including objects) will be included during import unless if the owner is SYS. this is because SYS objects are not recreated during import.

    by the way, i read in an article written by one of the ORACLE gurus which states that the SYSTEM schema were being retrieve during import. but, just to make sure i believe we have to validate it.

    i hope this would help you...

    "Let's get it on..."

  4. #14
    Join Date
    Sep 2000

    try this

    go for cold backup
    otherwise u will not be able to restore the whole data
    because 3 days before i got the same problem
    copy your datafile ,controlfiles,logfiles as well as init.ora
    and paste at the same place(means the path shoul be same)
    and startup your database

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.