Repord Create Table Duration

[ckwan]

Hi all,
I have a script to create all the tables. I create a script file called createtab.sh. Basically my script is to create numbers of tables. Inside my createtab.sh, sqlplus -s / $ORACLE_HOME/scripts/crttab1.sql,........crttab5

I want to record down the time for each table creation.
Any one can guide me on this ?

Thanks

[mike9]

In sql*plus you can execute a "set timing on" to display the time taken for a DML/DDL. To record the result I would add a spool command at the beging of your sql script.

So to record down the time for each table creation I would add at the begingin of your scripts the following 2 lines:

spool $ORACLE_HOME/.../crttab1.log
set timing on

[ckwan]

Is there any Unix command to write and append the timestamp to a file rather I manually combine ?

[pando]

man date?

[davey23uk]

If all you want to do it append the date to the file

date >> filename

will stick the date to the end of the file