transfer data from sql server to Oracle (URGENT)

[rohitkv]

Hi all,

My Problem is to transfer data from sql server to oracle.
I've already tried Data Transmission service (sql server). It exported the data successfully but when i tried to access it the following error came:

ORA-00942: table or view does not exist
Oracle is not recognizing the tables imported through DTS

Pls. suggest some way to transfer
thanx

 

[kllick123]

You can click on the transform button and
then you can click on create table on destination.

This will create table in your oracle database.

Arun Tayal

 

[rohitkv]

thanx kllick123

For such quick response...
but i am not getting u what ur trying to say....
Pls. explain

rohit

 

[uparna]

Hi Rohit ,
When you are doing the DTS export import , click on the data transformation tab , and then click the source and destination tables. Be sure to preview the data before you do the final click. Regards,
S. Jayaram Uparna .