OraFAQ Forum: SQL & PL/SQL » Getting Log information in PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Getting Log information in PL/SQL (Oracle,Windows)

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

Getting Log information in PL/SQL [message #315354]

Mon, 21 April 2008 04:58

oracleram
Messages: 23
Registered: November 2006

Junior Member

Dear Every one,
Kindly help me to write a PL/SQL program to get the Log information(while copying the data) in oracle,its very urgent yar,do the needful,Thanks in advance.

Thanks & Regards,

Ram Nainar S

Be in Love with the Divine...

Report message to a moderator

Re: Getting Log information in PL/SQL [message #315359 is a reply to message #315354]

Mon, 21 April 2008 05:09

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

You have posted in the PL/SQL Experts forum. This implies that you consider yourself to be an expert. One thing that an expert would most definitely have done would have been to try several possible solutionjs themselves prior to asking for assistance. So why don't you post what you have already done, maybe someone can spot where you went wrong.

edit

Quote:

Be in Love with the Divine...

I'd rather not, I have a wife and I don't know whether the divine is up for that kind of thing.

[Updated on: Mon, 21 April 2008 05:10]

Report message to a moderator

Re: Getting Log information in PL/SQL [message #315427 is a reply to message #315354]

Mon, 21 April 2008 08:13

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

oracleram wrote on Mon, 21 April 2008 05:58

Kindly help me to write a PL/SQL program to get the Log information(while copying the data) in oracle

What does this mean?

Report message to a moderator

Re: Getting Log information in PL/SQL [message #315434 is a reply to message #315427]

Mon, 21 April 2008 08:33

oracleram
Messages: 23
Registered: November 2006

Junior Member

Hi,

This means i want PL/SQL block that is to display the log information like when the data is copied,Thanks in advance.

Thanks & Regards,

Ram Nainar S

[Updated on: Mon, 21 April 2008 08:34] by Moderator

Report message to a moderator

Re: Getting Log information in PL/SQL [message #315439 is a reply to message #315434]

Mon, 21 April 2008 08:54

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Depends.

what do you mean by "Display"
what do you mean by "Log Information"
what do you mean by "Data"
what do you mean by "Copied"

Report message to a moderator

Re: Getting Log information in PL/SQL [message #315445 is a reply to message #315439]

Mon, 21 April 2008 09:03

oracleram
Messages: 23
Registered: November 2006

Junior Member

Dear Thomas,
Thanks for your valuable attention into this,i want to write a PL/SQL block to get the log information(normal log information).Thanks in advance.

Thanks & Regards,

Ram Nainar S

Be in Love with the Divine...

Report message to a moderator

Re: Getting Log information in PL/SQL [message #315446 is a reply to message #315445]

Mon, 21 April 2008 09:09

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This does not answer Thomas questions.
And as it has already been asked to you, please avoid your religious remark, you may offend some.

Regards
Michel

Report message to a moderator

Re: Getting Log information in PL/SQL [message #315449 is a reply to message #315446]

Mon, 21 April 2008 09:14

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Well, since we still have not idea what the actual question is, maybe I give some answer that answers something vaguely in that direction :

PL/SQL procedure to create an external table to read the alert.log in Oracle.

Maybe someone finds it useful. Very Happy

Report message to a moderator

Previous Topic:	Need help in copying CLOB data over DBlink
Next Topic:	Display column_name and column_value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 18 20:49:38 CDT 2025