Hang on import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Hang on import

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Posts
    15
    Hi there,
    I have a script that I run which performs some SQL to remove a user and then runs an import which creates the user and the objects that the user owns (Exported for a live DB).
    When I run this script manually, it works fine but when the script is left to run though at it seems to hang leaving no relevant messages for me to use to debug the problem. We are running NT 4 with Oracle 8.0.4.

    Here is the script:

    e:
    cd \ora-script
    set oracle_sid=azr2
    sqlplus /nolog @e:\ora-script\azr2_ezl.sql
    * Up until this point it all works, it hangs on the import *

    imp80 system/manager@azr2 file=h:\ezt1.dmp commit=y ignore=y log=e:\ora-script\impazr2.log full=y

    Any help would be appreciated.

    Thanks,

    Mark



  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    You are trying to import full database (FULL=Y) where as the export dump file was taken at user level.
    Change the imp parameter.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Not true! FULL=Y as an import parameter only means that you want the whole contents of the dump file to be imported. So it doesn't matter if export was done at FULL, USER or TABLE level. Parameter FULL has totaly different meaning in imp as it has in exp.

    To the original question:

    Under which user is the Scheduler service runing on NT? As a SYSTEM acount or as a named user? Are the H: and E: disks local disks or are they mounted remote disks?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jul 2001
    Posts
    15

    Exclamation

    Hi Guys,
    Thanks for getting back to me.

    H: is a mounted drive, it's the E drive from the live server which is where I store my dumps, I guess it would also help for me to show you how the file is dumped:

    set oracle_sid=ezt1
    exp80 system/manager file=e:\backup\ezt1.dmp grants=y indexes=y rows=y constraints=y log=e:\backup\ezt1.log full=y

    I know in this case that I should really only be doing a user export, but I have little Oracle experience nor time to look into how to do one. I might ask about that later if that's OK.

    I'm using at to schedule the dump, as you can see it dumps from the system user.

    Any help will be great!

    Cheers,

    Mark

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