Change the Initial extent size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Change the Initial extent size

  1. #1
    Join Date
    Dec 2001
    Posts
    221
    I'm having a table with initial extent size 10M. i've to change it to default or some value say 64 k.

    i've to recreate the object with next extent size. right ?

    if support i've export dump with me containing the table. is it possible to import with next extent size.

    i've tried with compress= y the extent size didn't change to default.

    Santosh Jadhav
    8i OCP DBA

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    The best way to proceed is further:

    1)Drop the exisiting table.
    2)Import the table but without rows and indexes to create a script file of the table.

    imp system/manager file=abc.dmp log=a.log rows=n indexes=y fromuser=scott touser=scott tables=emp indexfile=script.sql

    3)Edit the script.sql file and change the necessary parameters ie.change initial extent 64K instead of 10M .Save the file and run the script.sql and create the table and dont create the indexes.

    4)Again run the import command and now with rows=y and indexes=y

    imp system/manager file=abc.dmp log=a.log rows=y indexes=y fromuser=scott touser=scott tables=emp ignore=y commit=y constraints=y

    Regards,
    Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
    oracle-support@indiatimes.com



    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

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