-
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
-
trace the process, what is it doing
-
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.
-
trace the process, what is it doing
-
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?
-
trace the process, what is it doing (see the repetition here?)
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|