Hi all ,

I have two questions for you .

1 how can i improve performance of my import export command utility . load is not a option .

2 . Can i reassign a table to a new tablespace without dropping or recreating the table any way to alter ...

Thanks
Sandeep

1. IMPORT is just a series of inserts and the usual methods of improving insert performance will apply. Drop indexes, disable constraints, increase the bufferpool and NUM_IOSERVERS.

2. No.

1> commitcount
2> No

Thanks a lot guys !