DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to Alter INITRANS of a Table

  1. #1
    Join Date
    Mar 2003
    Posts
    32

    How to Alter INITRANS of a Table

    Hi

    I want to change the initrans of some of my tables.
    I tried the alter command but its not working.

    Can any of u plz give me an example of how alter inittrans of a table.

    Im using Oracle 9i version 1.0.1.1.1 on Windows 2000 server.
    Regards Zeeshan!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    alter table X initrans Y

    only new blocks will have new initrans though

  3. #3
    Join Date
    Mar 2003
    Posts
    32
    Thanx Pando.

    U r really great.
    Regards Zeeshan!

Posting Permissions

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


Click Here to Expand Forum to Full Width