DTS from sql server to oracle

0. Before -> Finished oracle client and sql server client installation, then prepared tnsnames.ora setting on the host

1. DTS

1.1 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtswiz.exe

1.2 click properities

1.3 fill the server_name -> tnsnames.ora entry , database identifier

1.4 choose a destinstation

1.5 start export and import