OraFAQ Forum: General » How to set retention policy for a table ?(2 Merged)

Home » Other » General » How to set retention policy for a table ?(2 Merged) (oracle 11.2.0.1.0 IBM AIX. 5.3 )

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

How to set retention policy for a table ?(2 Merged) [message #505709]

Wed, 04 May 2011 11:37

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Dear Sir / Madam,
Please guide me how to set retention policy for a table in oracle using DBINFO.DB_RETENTION ?

before resize / add a datafile in a tablepace, we need to check the retention policy for a specific table....

thank you,
Kesavan

Report message to a moderator

Re: How to set retention policy for a table ? [message #505710 is a reply to message #505709]

Wed, 04 May 2011 11:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>DBINFO.DB_RETENTION ?
OK, I give up.

Please post URL to where above is documented

Report message to a moderator

Re: How to set retention policy for a table ? [message #505714 is a reply to message #505709]

Wed, 04 May 2011 11:44

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

What is DBINFO.DB_RETENTION? Because we can't find it in the documentation.

Report message to a moderator

Re: How to set retention policy for a table ? [message #505718 is a reply to message #505714]

Wed, 04 May 2011 11:51

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Apologies for inconvenience happened. Under DBINFO schema, they have created DB_RETENTION table and they have kept retention policy info for each table in all databases.

I made mistake and wasted all your time. I am sorry.

Thank you,
kesavan

Report message to a moderator

Re: How to set retention policy for a table ? [message #505720 is a reply to message #505718]

Wed, 04 May 2011 11:55

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

Senior Member
Account Moderator

>>they have created DB_RETENTION tabl
Again, Who are "they"?
You should ask "them".

Report message to a moderator

Re: How to set retention policy for a table ? [message #505724 is a reply to message #505720]

Wed, 04 May 2011 12:10

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Hi Mahesh,

They are my onsite dba team.
I am checking with them now.

one sample row:

DB_NAME                        OWNER                          TABLE_NAME                     COLUMN_NAME                    SUBJECT_AREA         RETENTION_PERIOD       PURGE_FLG PURGE_EXCEPTION_FLG PARTITION_FLG RETENTION_TYPE FREQUENCY LAST_RUN_DT               CREATE_DT                 LAST_MODIFY_DT            LAST_RUN_STATUS 
------------------------------ ------------------------------ ------------------------------ ------------------------------ -------------------- ---------------------- --------- ------------------- ------------- -------------- --------- ------------------------- ------------------------- ------------------------- --------------- 
TEDW                           EQUIPMENT                      ETHRNT_VRTL_CNXN_DLY_AGG       TIME_KEY                       EQUIPMENT            14                     Y         N                   Y             M              DAILY     06-APR-11                 25-MAR-11                 06-APR-11 10.58.34.000000000 AM Passed

I am sorry for the incon(.)

Thank you,
kesavan

Report message to a moderator

Re: How to set retention policy for a table ? [message #505731 is a reply to message #505724]

Wed, 04 May 2011 12:19

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

Senior Member
Account Moderator

This is NOT an Oracle standard table.
This is a custom one.
Ask the one that created it what it means and how to manage its data.

Regards
Michel

Report message to a moderator

Previous Topic:	install 9iR2 Oracle DW
Next Topic:	Oracle Partner Network

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:32:54 CST 2024