DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    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
    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

    Rohit Nirkhe,Oracle/Apps DBA,OCP 8i

    Thanks and Regards
    Rohit S Nirkhe

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.