Import Hanging-no Error Msg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Import Hanging-no Error Msg

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Import Hanging-no Error Msg

    HI EVERY RAVENS, STEELERS,AND GIANT FANS,

    The following is a snapshot of my import hanging at the character set.

    Export was successful. I was trying to export from db1 and import to db2 on the same server.

    Microsoft Windows 2000 [Version 5.00.2195]
    (C) Copyright 1985-2000 Microsoft Corp.

    C:\>SET ORACLE_SID=DB2

    C:\>J:

    J:\>imp system/manager full=y file=exp_full.dmp recordlength=65535 commit=n analyze=n ignore=y buffer=5000000

    Import: Release 8.1.7.0.0 - Production on Thu Oct 31 22:13:04 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to: Oracle8i Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production

    Export file created by EXPORT:V08.01.07 via direct path

    Warning: the objects were exported by app_user_name, not by you

    import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

    is there any problem with the character set?
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: Import Hanging-no Error Msg

    Originally posted by Ablakios

    J:\>imp system/manager full=y file=exp_full.dmp recordlength=65535 commit=n analyze=n ignore=y buffer=5000000

    You could do the same with 'commit=y'. You should also check your alert log for any error messages during import.

    HTH.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    Darn Ravens fans!!

    You should set commit=Y As ggnanaraj mentioned.
    Why specify a buffer if you do not commit?
    You are making less sense then our pathetic offense.


    Seriously, if you do not use the commit Oracle will attempt to load the entire table before it commits.
    If the table is too big and this fails, it will take time to rollback all that was imported.



    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Hey Mr.Hanky the GIANT
    If I am not mistaken setting commit=y will tell Oracle to commit after every table and help to avoid ORA-01562 Failed to extend RBS.
    What if I have a lot of tables and big ones? In my case I do and I sure don't want Oracle to commit after every table. Does it make sense now?

    Below is the same import hanging with COMMIT=Y as you suggested.

    Microsoft Windows 2000 [Version 5.00.2195]
    (C) Copyright 1985-2000 Microsoft Corp.

    C:\>SET ORACLE_SID=db2
    C:\>J:

    J:\>imp system/manager full=y file=exp_full.dmp recordlength=65535 commit=Y ignore=y buffer=5000000

    Import: Release 8.1.7.0.0 - Production on Fri Nov 1 10:40:24 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Connected to: Oracle8i Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production

    Export file created by EXPORT:V08.01.07 via direct path

    Warning: the objects were exported by app_user_name, not by you

    import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

    What do you say now?
    Last edited by Ablakios; 11-01-2002 at 11:00 AM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    COMMIT in conjunction with BUFFER will tell Oracle to commit after ever ??? bytes.

    If buffer=4000000, than a commit will be issued after 4 million bytes (3 megs give or take). This way the commit is issued during the table import.
    http://technet.oracle.com/docs/produ...76955/ch02.htm

    The Oracle default is to try the entire table and if they are big it can blow out your RBS.

    How long does this hang for?
    Are you sure it has not started and is just reading the .DMP file?
    How big is the .DMP file?

    MH
    Last edited by Mr.Hanky; 11-01-2002 at 12:56 PM.
    I remember when this place was cool.

  6. #6
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    what is the configuration of your server??? and dumpfile size?? and howlong did you wait before coming to the conclusion that import is hanging??? It depends on the hardware configuration..
    -nagarjuna

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