DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008

    Re-Design of Database

    Lets guess that i had taken my whole "Sales" database backup by means of Oracle Export Utility which was in oracle 9i platform.
    Now i want that database backup in my oracle 10g platform by means of oracle Import Utility.
    I do have to do this changes in my new machine where only oracle 10g and my new OS with necessary all the application installed and there is not any backup is there on my machine.
    in that situation wt all are things that i have to consider at the time of Import.

    Thanks in Advance

  2. #2
    Join Date
    Sep 2002
    getting the import options right would be a good start

    also export is not a backup

  3. #3
    Join Date
    Jan 2008
    Thanks for the help.

    ya i know that import is the best option..
    but my question is that what all are the things that i have to consider at the time of importing...

    At the time of import which care i should have to take so that in future it wont create any problem.......

    i hope my question is clear now...

    thanks in advance.....

  4. #4
    Join Date
    Dec 2007
    1)Install 10g software.
    2create 10g database.
    3)import full database-(if directory structures are same of source and target)
    if not then..
    3a)pre-create all the tablespaces in target as in source database.
    then import full with ignore=y.

    Note:As said by davey export is not a backup .


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.