Change the Initial extent size

[sjadhavdba]

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.

[rohitsn]

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