Home » Other » General » How to set retention policy for a table ?(2 Merged) (oracle 11.2.0.1.0 IBM AIX. 5.3 )
How to set retention policy for a table ?(2 Merged) [message #505709] Wed, 04 May 2011 11:37 Go to next message
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
Re: How to set retention policy for a table ? [message #505710 is a reply to message #505709] Wed, 04 May 2011 11:39 Go to previous messageGo to next message
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
Re: How to set retention policy for a table ? [message #505714 is a reply to message #505709] Wed, 04 May 2011 11:44 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
What is DBINFO.DB_RETENTION? Because we can't find it in the documentation.
Re: How to set retention policy for a table ? [message #505718 is a reply to message #505714] Wed, 04 May 2011 11:51 Go to previous messageGo to next message
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
Re: How to set retention policy for a table ? [message #505720 is a reply to message #505718] Wed, 04 May 2011 11:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10696
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>they have created DB_RETENTION tabl
Again, Who are "they"?
You should ask "them".
Re: How to set retention policy for a table ? [message #505724 is a reply to message #505720] Wed, 04 May 2011 12:10 Go to previous messageGo to next message
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
Re: How to set retention policy for a table ? [message #505731 is a reply to message #505724] Wed, 04 May 2011 12:19 Go to previous message
Michel Cadot
Messages: 68055
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: install 9iR2 Oracle DW
Next Topic: Oracle Partner Network
Goto Forum:
  


Current Time: Wed Dec 08 10:46:08 CST 2021