Home » RDBMS Server » Server Administration » Information about dump in the Oracle, please help me to find...
Information about dump in the Oracle, please help me to find... [message #208395] Sun, 10 December 2006 05:04 Go to next message
amigo12.85
Messages: 5
Registered: December 2006
Junior Member

Hello, people!

I'm can't understand, how to work dump in the Oracle, please
help to find information about DUMP in the Oracle 10 g Release 2.

Yours faithfully, Amigo!
Re: Information about dump in the Oracle, please help me to find... [message #208402 is a reply to message #208395] Sun, 10 December 2006 07:43 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

You want to Know about Dump folder.
like
1.bdump
2.udump
3.cdump

the above all folder used to tracing for oracle database.
1.bdump :> Background Dump.
2.udump :> User Dump
3.cdump :> Core Dump

where any background problem occur then with bkground name trace files generate in bdump folder.
and Most important file "alert<sid>.log" file generate in bdump folder.

some like bdump, udump used for User Error. and user error occur or if user enable sql_tracing then Trace files generate in udump folder.

cdump > used some like bdump or udump for Oracle Error.
http://www.thescripts.com/forum/thread65941.html

hope this helps
Taj
Re: Information about dump in the Oracle, please help me to find... [message #208404 is a reply to message #208395] Sun, 10 December 2006 07:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> how to work dump in the Oracle,
Are you talking about export/import DUMPS?
Re: Information about dump in the Oracle, please help me to find... [message #208506 is a reply to message #208395] Mon, 11 December 2006 02:34 Go to previous messageGo to next message
amigo12.85
Messages: 5
Registered: December 2006
Junior Member

Mahesh Rajendran
Sorry, if i explain this problem bad. Just i from Russia, and i speak english not very well:( But i want to learn speak english, very want:)

>>Are you talking about export/import DUMPS?

Yes, i'm talking about export/import DUMPS. I want to know, how to create "dmp" file for export/import operation.

Yours faithfully, Amigo!
Re: Information about dump in the Oracle, please help me to find... [message #208510 is a reply to message #208506] Mon, 11 December 2006 02:44 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
go through below link
http://forums.oracle.com/forums/thread.jspa?messageID=1583608&#1583608


hope this helps
Taj

[Updated on: Mon, 11 December 2006 02:46]

Report message to a moderator

Re: Information about dump in the Oracle, please help me to find... [message #208524 is a reply to message #208510] Mon, 11 December 2006 03:48 Go to previous messageGo to next message
amigo12.85
Messages: 5
Registered: December 2006
Junior Member

user52
C:\>exp system/oracle owner=test file=c:\test.dmp log=c:\test.log
C:\>imp system/oracle fromuser=test touser=hr file=c:\test.dmp log=c:\test.log

I understand, how write command, but i don't understand how to create file "test.dmp"
What i must write when i creating this file????
Re: Information about dump in the Oracle, please help me to find... [message #208527 is a reply to message #208524] Mon, 11 December 2006 04:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I understand, how write command, but i don't understand how to create file "test.dmp"
>>What i must write when i creating this file??
when you say file=c:\test.dmp , oracle will logically export the data into a proprietory file called test.dmp.
You need to do nothing.
Never edit/write anything into this file.
Only the imp utility is allowed to read this file and import into another database.
Re: Information about dump in the Oracle, please help me to find... [message #208533 is a reply to message #208527] Mon, 11 December 2006 04:10 Go to previous message
amigo12.85
Messages: 5
Registered: December 2006
Junior Member

Mahesh Rajendran
Thanks for response very much. I think that i understand now.
Previous Topic: ORA-00200: control file could not be created
Next Topic: performace issue with indexing
Goto Forum:
  


Current Time: Sun Dec 11 08:32:46 CST 2016

Total time taken to generate the page: 0.08252 seconds