Home » SQL & PL/SQL » SQL & PL/SQL » Table dependency for Audit tables (Oracle 11.2.0.3 , Linux)
Table dependency for Audit tables [message #621964] Wed, 20 August 2014 03:32 Go to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Hi,

How to check dependency for cleaning up of the table audits ?

Regards,
Srijesh
Re: Table dependency for Audit tables [message #621970 is a reply to message #621964] Wed, 20 August 2014 04:09 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
*_CONSTRAINTS
Re: Table dependency for Audit tables [message #621973 is a reply to message #621970] Wed, 20 August 2014 04:21 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Thanks Lalit,

Is it not *_dependencies ? I am checking with you ?

Regards,
Srijesh
Re: Table dependency for Audit tables [message #621975 is a reply to message #621973] Wed, 20 August 2014 04:27 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
*_dependencies is for procedures/functions/packages/views/triggers.
The relationships between tables are defined by the foreign keys. Details of foreign keys are in the *_constraints and *_cons_columns views.

However oracle does supply a package the cleans up the audit tables for you.
Re: Table dependency for Audit tables [message #621976 is a reply to message #621973] Wed, 20 August 2014 04:32 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Srijesh wrote on Wed, 20 August 2014 14:51

Is it not *_dependencies ? I am checking with you ?


It's better you check the documentation than checking with me Razz

When you said tables, I thought about the relation among them, thus *_constraints. Rest CM has already explained.

Edit : typo

[Updated on: Wed, 20 August 2014 04:32]

Report message to a moderator

Re: Table dependency for Audit tables [message #621978 is a reply to message #621976] Wed, 20 August 2014 04:46 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Thanks Cookiemaster /Lalit for your answer.
Quote:
However oracle does supply a package the cleans up the audit tables for you.


What package is that and how do i use it ?

The requirement is user has one table "AUDIT" and wanted to ensure that if they are deleting rows from that AUDIT table , will it have any impact to some other table ? How to find out this ?

I think *_constaints will have the reference table name.Can you confirm ?

Regards
Srijesh
Re: Table dependency for Audit tables [message #621980 is a reply to message #621978] Wed, 20 August 2014 04:52 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Srijesh wrote on Wed, 20 August 2014 15:16

I think *_constaints will have the reference table name.Can you confirm ?


Why do you still have to think? You have the view name, explore it. Prepare your test case and understand.
Re: Table dependency for Audit tables [message #621981 is a reply to message #621978] Wed, 20 August 2014 04:53 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is this audit oracles own auditing or something a developer wrote?
If it's the former I suggest you read the documentation on auditing, if it's the later I suggest you asked the person who wrote it.
As for the contents of the *_constraints views - they are fully documented as well (all oracle supplied views are), have you read it?
Re: Table dependency for Audit tables [message #621988 is a reply to message #621980] Wed, 20 August 2014 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Lalit Kumar B wrote on Wed, 20 August 2014 11:52
Srijesh wrote on Wed, 20 August 2014 15:16

I think *_constaints will have the reference table name.Can you confirm ?


Why do you still have to think? You have the view name, explore it. Prepare your test case and understand.


Something impossible for Dumby Fraudy Balaji/Ajit/Jack/Mohan/Mathew/Suhas/Srini/william/Srikanth/david/Srijesh. Sad

Re: Table dependency for Audit tables [message #621989 is a reply to message #621981] Wed, 20 August 2014 05:38 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Hi Cookiemaster,

This table is created by developer and not oracle auditing table.

Michel,
Quote:
Something impossible for Dumby Fraudy Balaji/Ajit/Jack/Mohan/Mathew/Suhas/Srini/william/Srikanth/david/Srijesh. Sad

There is nothing impossible for a person and this should not have come out from your mouth. Very Happy
Re: Table dependency for Audit tables [message #621994 is a reply to message #621989] Wed, 20 August 2014 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
There is nothing impossible for a person


A person, maybe; but you yes indeed it is impossible, see 8 years DBA and you ask beginner questions (and even less than that as beginners are able to read the documentation).

Re: Table dependency for Audit tables [message #622001 is a reply to message #621994] Wed, 20 August 2014 06:52 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Quote:
A person, maybe; but you yes indeed it is impossible, see 8 years DBA and you ask beginner questions (and even less than that as beginners are able to read the documentation).


Oh is it ?? then leave this thread and look for some other threads which is suitable and equal to your experience level.

I thank Cookiemaster and Lalit for helping me on this thread .Though it was a beginner level question they atleast bother to answer me.

[Updated on: Wed, 20 August 2014 06:52]

Report message to a moderator

Re: Table dependency for Audit tables [message #622010 is a reply to message #622001] Wed, 20 August 2014 07:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The problem is that you are at level minus 1 and you are the only one at this level so if you wait for someone of your level to answer you you'd have to wait for very long.

Quote:
they atleast bother to answer me.


And you have bothered them with your stupidity and lazyness.

Re: Table dependency for Audit tables [message #622016 is a reply to message #622010] Wed, 20 August 2014 08:33 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Quote:
And you have bothered them with your stupidity and lazyness.

moodeekinuu poda

[Updated on: Wed, 20 August 2014 08:33]

Report message to a moderator

Re: Table dependency for Audit tables [message #622025 is a reply to message #622016] Wed, 20 August 2014 09:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Terms of abuse lead to banishment.

[Updated on: Wed, 20 August 2014 10:14]

Report message to a moderator

Re: Table dependency for Audit tables [message #622037 is a reply to message #622025] Wed, 20 August 2014 10:32 Go to previous message
EdStevens
Messages: 1350
Registered: September 2013
Senior Member
Michel Cadot wrote on Wed, 20 August 2014 09:28

Terms of abuse lead to banishment.



Whack-a-mole.
Better to simply starve the troll.
Previous Topic: How to find cardinality of a table in oracle
Next Topic: Compare and update Stored proc
Goto Forum:
  


Current Time: Fri Dec 03 05:34:58 CST 2021