| full database export [message #161269] |
Thu, 02 March 2006 23:40  |
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
|
Member |
|
|
C:\>exp 'sys/welcome123 as sysdba' file=c:\full.dmp grants=y full=y rows=y
Export: Release 9.2.0.1.0 - Production on Fri Mar 3 10:44:32 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 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
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00008: ORACLE error 1041 encountered
ORA-01041: internal error. hostdef extension doesn't exist
EXP-00000: Export terminated unsuccessfully
how can i solve this problem ? explain with some example
|
|
|
|
|
|
| Re: full database export [message #161276 is a reply to message #161272] |
Fri, 03 March 2006 00:48  |
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
|
Member |
|
|
hi,
i found solution for my issue.
i check in alertlog file and find that default tablespace was changed .
"ORA-1652: unable to extend temp segment by 2048 in tablespace TEMPEXTRA "
after changing the default tablespace to correct one , the problem is solved.
atlast without any error, i can export whole database.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
