DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: exporting object type definitions --gets stuck

  1. #1
    Join Date
    May 2008
    Posts
    1

    exporting object type definitions --gets stuck

    Hello all,

    I am new to this forum. This is an urgent request.
    I am having Oracle 9 version.
    I want to export my Database.

    i opted for EXP executable from Oracle_home/bin directory

    It took me to Interactive mode.

    I connected using : username AS SYSDBA
    and password.

    Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
    With the Partitioning and Oracle Data Mining options
    JServer Release 9.2.0.3.0 - Production
    Enter array fetch buffer size: 4096 >
    Export file: EXPDAT.DMP >
    (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > E -----> I gave E
    Export grants (yes/no): yes >
    Export table data (yes/no): yes >
    Compress extents (yes/no): yes >
    Export done in WE8DEC character set and AL16UTF16 NCHAR character set

    About to export the entire database ...
    . exporting tablespace definitions
    . exporting profiles
    . exporting user definitions
    . exporting roles
    . exporting resource costs
    . exporting rollback segment definitions
    . exporting database links
    . exporting sequence numbers
    . exporting directory aliases
    . exporting context namespaces
    . exporting foreign function library names
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions ----------> it gets stuck over here

    Please help me to solve this problem. Please explain me why the execution got stuck on that line.

    Thanks in advance
    Sunil C

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    trace the process, what is it doing

  3. #3
    Join Date
    May 2008
    Posts
    1
    I am completely confused.

    i want to export the entire database ( option E)
    i tried to login using username for DB.

    user AS SYSDBA
    password

    and then when executing it gets stuck in that line..

    i tried different login

    SYS AS SYSDBA
    user AS SYSDBA

    still same result.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    trace the process, what is it doing

  5. #5
    Join Date
    May 2008
    Posts
    1
    Hello Sir,

    my Database is in windows.
    So i am running EXP.exe executable to open the export window.

    So when it gets stuck in that line, i checked the Task Manager to see the process. It is not showing this process.

    is there any other way sir?

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    trace the process, what is it doing (see the repetition here?)

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    You are not listening, Dave told you what to do twice -three times now. Trace it.

    Operating system is immaterial, it's Oracle

    Trace the session please
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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