OraFAQ Forum: Server Administration » Information about dump in the Oracle, please help me to find...

Home » RDBMS Server » Server Administration » Information about dump in the Oracle, please help me to find...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Information about dump in the Oracle, please help me to find... [message #208395]

Sun, 10 December 2006 05:04

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!

Report message to a moderator

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

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> how to work dump in the Oracle,
Are you talking about export/import DUMPS?

Report message to a moderator

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

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!

Report message to a moderator

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

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

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????

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

amigo12.85
Messages: 5
Registered: December 2006

Junior Member

Mahesh Rajendran
Thanks for response very much. I think that i understand now.

Report message to a moderator

Previous Topic:	ORA-00200: control file could not be created
Next Topic:	performace issue with indexing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:40:49 CDT 2024