• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

Creating partition tables tables that contain LOBs.

what is the difference between  -  PCTVERSION or RETENTION  in create table statement..?
when to use PCTVERSION and when to use  RETENTION ...?
0
Rao_S
Asked:
Rao_S
  • 3
  • 2
3 Solutions
 
slightwv (䄆 Netminder) Commented:
Have you already read what is in the docs on these?

http://download.oracle.com/docs/cd/E11882_01/appdev.112/e18294/adlob_tables.htm#CIHEHGCH

I've not used either of these parameters so cannot provide explicit detail into when to use one over the other.

I've done a lot with CLOBs and have never set either one.
0
 
Rao_SAuthor Commented:
i was reading that document...and found it confusing, so wanted to check if somebody would explain in simple terms...
0
 
sdstuberCommented:
they both have to deal with how old data in the LOBs is preserved in UNDO


pctversion (default in manual undo) - specifies how much of the old undo to keep.

So, if you have 50, it will keep the old data until half of your lob storage is consumed.

retention (default in automatic undo) - specifies how much undo should be consumed to keep old data.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
sdstuberCommented:
to elaborate further...

RETENTION MAX -  this means all lob changes will be maintained until you run out of UNDO

RETENTION MIN 10 - this means enough undo storage will be used to store 10 seconds worth of changes,
 if you use this, you'll likely want a bigger number, I just picked 10 as an example.

RETENTION AUTO  (or just RETENTION, letting it default) - this will maintain undo to support read consistency for any active transactions
  this means anybody else selecting from the table will still be able to use old versions of your data that had been accessed before changes were commited.

RETENTION NONE - just what it sounds like,  no undo will be used. If you change the data, it's gone.


does that help?
0
 
Rao_SAuthor Commented:
hi sdstuber, that is really helpful..!!! thank you very much!
0
 
Rao_SAuthor Commented:
thank you!!!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now