Problems when importing on NT
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Problems when importing on NT

  1. #1
    Join Date
    Nov 2000
    Posts
    42

    Unhappy

    Hi!

    I'm attempting to migrating my database from Unix to NT.

    In Unix, my tablespaces are in '/u02/oradata/SID/rbs01.dbf'...
    But in NT I've got my DataBase in 'd:\orant\'.

    I succeed in export on Unix (I created a 'devexport.dmp' file), but
    when trying to import on NT, I get this error:

    ----//----
    Connected to: Oracle8 Release 8.0.5.0.0 - Production
    PL/SQL Release 8.0.5.0.0 - Production

    Export file created by EXPORT:V08.00.04 via conventional path
    IMP-00017: following statement failed with ORACLE error 1119:
    "CREATE TABLESPACE "RBS" DATAFILE '/u02/oradata/SID/rbs01.dbf' SIZE 15728640"
    " DEFAULT STORAGE (INITIAL 131072 NEXT 131072 MINEXTENTS 2 MAXEXTENTS "
    "121 PCTINCREASE 0) ONLINE PERMANENT"
    IMP-00003: ORACLE error 1119 encountered
    ORA-01119: error in creating database file '/u02/oradata/SID/rbs01.dbf'
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    ....
    ....

    Could anybody give any suggestion?

    Thank you very much
    ========
    LARRY ELLISON

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    In the NT DB you have to create tablespaces with the same names as they have in the UNIX DB.

  3. #3
    Join Date
    Nov 2000
    Posts
    42

    Question LET'S SEE...

    Thank you very much for answering.

    + I create a database on my NT server.

    + I create the tablespaces with THE SAME NAME as the Unix Originals.

    create tablespace SAMENAME datafile 'd:\foo\foo.dbf' size
    10m autoextend on next 5m maxsize 50m;

    + And d:\foo\foo.dbf ? Must it be the same as Unix?

    + And the size? Must it be similar?

    Thank you very much...

    ========
    LARRY ELLISON

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    try your import with the ignore=y option.
    Vinit

  5. #5
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    precreate the tablespace and then import objects
    sonofsita
    http://www.ordba.net

  6. #6
    Join Date
    Oct 2000
    Posts
    467
    wait a sec, Seems like the oracle version on Unix and NT are different. ? Have u checked that up ?
    Vinit

  7. #7
    Join Date
    Nov 2000
    Posts
    42

    Unhappy VERSIONS

    Thank you very much for answering again.

    You are right, Unix version is 8.0.4 and NT version is 8.0.5.

    Is it VERY important??? Wich are the risks???
    ========
    LARRY ELLISON

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    AFAIK, export from v 8.0.4 and import into v8.0.5 shouldn't be a problem. As this was a forward progress..

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #9
    Join Date
    Nov 2000
    Posts
    42

    Question ONE TABLESPACE AND FIVE DATAFILES

    Hi!

    Thank you very much for answering.

    Checking my Unix DB, I see:

    TablespaceName | Datafile
    =====================
    NAME /foo/database/wm_eles_.dat
    NAME /foo/database/wm_erels_.dat
    NAME /foo/database/wm_files_.dat
    NAME /foo/database/wm_frels_.dat
    NAME /foo/database/wm_infos_.dat

    How can I mirror it on my NT box?

    create tablespace....

    TIA
    ========
    LARRY ELLISON

  10. #10
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The export does a logical export and not the physical. So you don't have to worry about file struecture. Instead, go ahead and create the appropriate tablespaces with whatever the file names you like and then do the import with ignore=Y. That would get all your data imported into.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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