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
    Posts
    198
    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
    Location
    greenwich.ct.us
    Posts
    9,092

    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

  3. #13
    Join Date
    Nov 2000
    Posts
    15
    hello,

    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...

    cardinal
    "Let's get it on..."

  4. #14
    Join Date
    Sep 2000
    Posts
    305

    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