Re-Design of Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Re-Design of Database

  1. #1
    Join Date
    Jan 2008
    Posts
    39

    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
    Location
    England
    Posts
    7,333
    getting the import options right would be a good start

    also export is not a backup

  3. #3
    Join Date
    Jan 2008
    Posts
    39
    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
    Posts
    55
    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 .

    Regards

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