Oracle Database Discussions

Hi Guys,

This is in sequence with my first two posts...i'lll explain the whole scenario....

I have a 44 GB table on an Oracle DB 9.2.0.8. I first tried to truncate it but it was taking huge amount of time...

So, i truncated the table with:-
SQL> Truncate table TABLENB REUSE STORAGE;

After this i tried to Drop the table and it took approx 16-18 hrs to drop it. Now, i have started a import of the table using following command:-


imp schema/passwd
file=/oracle/XX/97/imp/TABLENB.1.exp,/oracle/XX/98/imp/TABLENB.2.exp,/oracle/XX/99/imp/TABLENB.3.exp log=/oracle/XX/97/exp/TABLENB.imp.log tables=TABLENB feedback=10000 indexes=N ignore=Y

It has taken 16 hrs till now and when i run the following query the output is as follows:-

SQL> select extents from dba_segments where segment_name='TABLENB';

EXTENTS
----------
12450


Initially the table had about 1 million extents....

Can somebody tell, is dere any way i can speed up the import process or is dere any lock on the table which is making the import slow????

Regards,
Nick.

Message was edited by:
Nick-- wud b DBA