Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48

    Unhappy Unanswered: changing pctversion

    hi,

    I want to change the 'pctversion' of a table (containing a lob)
    default is 10, but I need to get it higher for resolving the 'snapshot too old (rollback segment ...)'-error

    How do I do that in Oracle8 ?

    I tried with :
    alter table table_name modify lob lobname
    store as
    (
    tablespace tablespace_name
    pctversion 20)

    but that is not correct, can anyone help me please?

    thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    This certainly works on 8.1.7...

    ALTER TABLE <tabname>
    MOVE TABLESPACE <tsname> -- Tablespace for non LOB columns
    LOB (<lobcolumn(s)>) -- list of lob columns affected
    STORE AS
    (TABLESPACE <lobtsname> -- destination lob tablespace
    ENABLE STORAGE IN ROW -- alter the rest as appropriate
    PCTVERSION 40
    NOCACHE NOLOGGING);

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  3. #3
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48
    I know that it can also be done like that, but this is also for moving out to another tablespaces? But that is not necessary.

    Of course I can also fill in the same tablespace names, that will work, but it would also be nice if it would work without that moving, or doesn't that matter much?

    in anyway, thanks!

  4. #4
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    I just tried as follows..

    ALTER TABLE <tabname>
    MOVE
    LOB (<lobcolumn>)
    STORE AS
    (TABLESPACE <lobts>
    ENABLE STORAGE IN ROW
    PCTVERSION 40
    NOCACHE NOLOGGING);

    And it seemed happy, I haven't checked the result though :-)

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  5. #5
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    I should add that you can move it into the same tablespace to alter the storage parameters.

    Cheers
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  6. #6
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48
    Hi,

    I tested it on a 817 database, works ...
    but I also need it on an 805 database, there I get an error:
    ora-14004 : missing partition keyword

    any idea? or is this not supported/working on 805?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •