Database Migration : Unix --> Nt
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Database Migration : Unix --> Nt

  1. #1
    Join Date
    Sep 2000
    Posts
    64
    Hello,

    We intend to migrate our 7.3.4 database (Unix HP-UX 10.20) to an NT machine (with Oracle 8.1.7) using export/import utilities. My question is related to export. I am asking my self is a full export will work (because we will go from Unix to NT). Do you have an idea ?

    Thanks a lot

    Sofiane
    Sofiane

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    full export or oracle migration utility are two of your choices here .now for the choice given my experience for this kind of jobs i would say

    if the databse is small say a few gigs then export import is okay.

    if the databse is terrabytes then export import is big no no oracle migration utility or workbench si ideally suited to handed this kind of jobs

    this is not a final advice would love to see others opinions on this one


    hth
    hrishy

  3. #3
    Join Date
    Sep 2000
    Posts
    64
    Hello,

    We are going to migrate from Oracle 7.3.4 runing on UNIX PLATFORM to Oracle 8.1.7 runing on NT.
    So I think that using migration utility is not possible. Correct me if I am wrong.

    So my question si the following :

    If we perform a FULL export of our 7.3.4 (UNIX) database, the export file will contain the tablespace definition (with the differents db files : /u1/dbora/... ). In NT, we will create the DB with the same tablespaces (with the differents db files d:\dbora1, e:\...). SO I WOULD LIKE TO KNOW IL WE WILL BE ABLE TO IMPORT A FULL DMP FILE Into oracle 8.1.7 (runing under NT). NB : the FULL DMP FILE was exported from Oracle 8.1.7 (RUNING UNDER UNIX).

    NB : if that is not possible, we will perform export/import of the objects for each users.

    I am waiting for reply.

    Thanks

    Sofiane
    Sofiane

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I did EXP/IMP couple of times from NT to Unix. It works. It should work even other way from Unix to NT.The bottom line, u should be having the precreated tablespaces in the NT database. You should be oK.

    You can import full dmp, no need to user by user.
    Reddy,Sam

  5. #5
    Join Date
    Sep 2000
    Posts
    47
    I agree that the export/import should work. Just a reminder that the export utility does NOT export data from the SYS or SYSTEM schemas (even if you do a FULL export). Therefore, the roles, privileges and users you have defined will not be part of your export. You can generate the role/privilege/user create scripts by querying the original database, then execute them against your target before you do your import. The plus doing it this way (rather than recreating from scratch) is that your users will not have to reset their database passwords (assuming their not "identified externally").

    Tim

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    [QUOTE][i]Originally posted by macswell [/i]
    [B]I agree that the export/import should work. Just a reminder that the export utility does NOT export data from the SYS or SYSTEM schemas (even if you do a FULL export). Therefore, the roles, privileges and users you have defined will not be part of your export. You can generate the role/privilege/user create scripts by querying the original database, then execute them against your target before you do your import. The plus doing it this way (rather than recreating from scratch) is that your users will not have to reset their database passwords (assuming their not "identified externally").

    Tim [/B][/QUOTE]
    Just a small correction: schema SYSTEM *will be* exported with full exp just like any other user (that is what it realy is: a normal user with DBA privileges). Also all the roles, users, privileges *will be* exported (and also imported). In fact, this is the only way to transfer the users from one database to the others without changing their passwords and without actually knowing their passwords. (If you should try to precreate them with the scripts gathered from your source database dictionary you should use "... IDENTIFIED BY VALUES '....' ...." trick that export uses internaly, but this is another story.)

    Sreddy made a good point: you should precreate the tablespaces before importing, because the directory paths are expresed differently on NT and Unix (backslash and slash characters...), so import will fail that part on NT.

    Another frequently mistake when transfering .dmp from one machine to the other vith ftp: don't forget to transfer it in binary mode!
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    Going from Unix to NT.....

    Why do I have cold chills running down my spine???
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

  8. #8
    Join Date
    Feb 2001
    Posts
    41
    Export/Import utilities is the only option for you because you are switching between databases and platform.
    Make sure to run catalog.sql, catproc.sql and utlrp.sql. If you are using replication then run utlrep.sql also.
    Sys user grants given to other users are not exported so use some application to just export the grants or find a script that will generate all the grants given from sys schema. I have the script email me I will email you the script of sys (table and col level grants ) they are important but not discusses a lot in issues because very less people use exp/imp for migration unless it's different, i used it.
    hope this helps
    Best Regards,
    Harsh Shah

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    [QUOTE][i]Originally posted by wjramsey [/i]
    [B]Going from Unix to NT.....

    Why do I have cold chills running down my spine??? [/B][/QUOTE]
    Amen, brother.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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