You can increase the number and/or the size of your logs. For future
references, you may want to look at creating a table with the 'NOT LOGGED
INITIALLY' feature. When adding a new index, the table can be altered to
activate the above feature so that logging will not occur. Look at the
documentation for more details.
Mauro.

"yongsing" <ohyongsing@yahoo.com.sg> wrote in message
news:59fdb1b8.0311060042.cb9d87e@posting.google.co m...
> I tried to create an index on a column of a table. It failed because
> the creation caused the transaction log to be full. What can I do?
> Should I export out the data in the table, then recreate the table
> with the index, and finally import back the data?
>
> Thanks in advance.
>
> Yong Sing