I have a requirement of loading millions of data Using
Sql_loader. Here I have given a script that tells the current process
of loading data into Oracle tables. The data is appended into the
respective tables in Oracle. After that all the indexes are rebuild and

I have two questions (Oracle 9.2.0.7):
- What is the different from a "normal" temporary tablespace and a
temporary tablespace using temp file? I think that every objects
created on temporary tablespace will not generate any redo (except redo