Home » RDBMS Server » Server Administration » IS there any easy way to UNDERSTAND DB.... (10.2.3.0)
IS there any easy way to UNDERSTAND DB.... [message #381233] Thu, 15 January 2009 23:26 Go to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi all. This is sriram.....first of all,please ignore if any mistakes..am not a native speaker.if any format mistakes...i will correct by next message....so let me know if any.. I AM new to my job DBA(FRESHER).Is there any easy method to understand DB...i mean..i want to know, if anyone did any DML i will create one trigger to know which one is modified.....BUT my problem is i have 1000 tables...so is there any way to find directly...find changes made into those tables... (affected tables)
Re: IS there any easy way to UNDERSTAND DB.... [message #381234 is a reply to message #381233] Thu, 15 January 2009 23:29 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

query DBA_OBJECTS

[Updated on: Thu, 15 January 2009 23:30]

Report message to a moderator

Re: IS there any easy way to UNDERSTAND DB.... [message #381257 is a reply to message #381233] Fri, 16 January 2009 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You know...I mean...the way you write.....I mean....is...you know...hard to read...you see...I will say...read documentation...http://tahiti.oracle.com......
Re: IS there any easy way to UNDERSTAND DB.... [message #381268 is a reply to message #381257] Fri, 16 January 2009 01:07 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
documentation...http://tahiti.oracle.com......

Thank you Michel....
thank you for your kind response,
Quote:
first of all,please ignore if any mistakes..am not a native speaker.if any format mistakes...i will correct by next message....so let me know if any..
as i posted before that i do not know really how to post the question.i just used those dots(...) to ask the forum without any confusion,but based on those you are simply blaming pointing me on my mistakes.i have seen your previous messages also.but those are in good way.my institute environment is totally different from my company environment that is why i raised that question. without having real experiance no one is best.
Quote:
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.
i think this is the best way for me to read.i hope you may understand my problem thank you
Regards
Sriram.

[Updated on: Fri, 16 January 2009 01:17]

Report message to a moderator

Re: IS there any easy way to UNDERSTAND DB.... [message #381271 is a reply to message #381268] Fri, 16 January 2009 01:18 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ramoradba
if anyone did any DML i will create one trigger to know which one is modified.

If I understood you correctly, perhaps you'd want to enable auditing (instead of writing a trigger per table (having in mind that there are far too many of them).
Re: IS there any easy way to UNDERSTAND DB.... [message #381311 is a reply to message #381271] Fri, 16 January 2009 04:58 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thank you Littlefoot.
Auditing is fine.but Why i posted this query is to know & learn like we can create one trigger to record the sql-DDL statements on both schema & database level into a table,in same way we can record the DML changes only on purticular table.so my qyestion is --is it possible to write the dml trigger at schema level ? based on the documentation,i learned it is not possible,but because of my curiosity i am asking.
Re: IS there any easy way to UNDERSTAND DB.... [message #381316 is a reply to message #381311] Fri, 16 January 2009 05:36 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, the answer is NO.
Previous Topic: SYS.INITJVMAUX Invalide during oracle 9i to 11g upgrade
Next Topic: Security Patches
Goto Forum:
  


Current Time: Wed Dec 07 03:00:38 CST 2016

Total time taken to generate the page: 0.13341 seconds