OraFAQ Forum: SQL & PL/SQL » Table dependency for Audit tables

Home » SQL & PL/SQL » SQL & PL/SQL » Table dependency for Audit tables (Oracle 11.2.0.3 , Linux)

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

Table dependency for Audit tables [message #621964]

Wed, 20 August 2014 03:32

Srijesh
Messages: 24
Registered: August 2014
Location: Berlin

Junior Member

Hi,

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

Regards,
Srijesh

Report message to a moderator

Re: Table dependency for Audit tables [message #621970 is a reply to message #621964]

Wed, 20 August 2014 04:09

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

*_CONSTRAINTS

Report message to a moderator

Re: Table dependency for Audit tables [message #621973 is a reply to message #621970]

Wed, 20 August 2014 04:21

Srijesh
Messages: 24
Registered: August 2014
Location: Berlin

Junior Member

Thanks Lalit,

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

Regards,
Srijesh

Report message to a moderator

Re: Table dependency for Audit tables [message #621975 is a reply to message #621973]

Wed, 20 August 2014 04:27

cookiemonster
Messages: 13961
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.

Report message to a moderator

Re: Table dependency for Audit tables [message #621976 is a reply to message #621973]

Wed, 20 August 2014 04:32

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

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

Report message to a moderator

Re: Table dependency for Audit tables [message #621980 is a reply to message #621978]

Wed, 20 August 2014 04:52

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.

Report message to a moderator

Re: Table dependency for Audit tables [message #621981 is a reply to message #621978]

Wed, 20 August 2014 04:53

cookiemonster
Messages: 13961
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?

Report message to a moderator

Re: Table dependency for Audit tables [message #621988 is a reply to message #621980]

Wed, 20 August 2014 05:28

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

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

Report message to a moderator

Re: Table dependency for Audit tables [message #621989 is a reply to message #621981]

Wed, 20 August 2014 05:38

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

Report message to a moderator

Re: Table dependency for Audit tables [message #621994 is a reply to message #621989]

Wed, 20 August 2014 05:54

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

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).

Report message to a moderator

Re: Table dependency for Audit tables [message #622001 is a reply to message #621994]

Wed, 20 August 2014 06:52

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

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

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: