Oracle to SQL SERVER

Oracle 9i to SQL 2K
Can someone shed some light , how can I create SQL server db objects from
the dmp file (export from Oracle).
I need to create the schema and later load data in SQL SERVER..
Any links or related topics will be highly appreciated.
Thanks
ShThis should help:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part2/c0761.asp
I don't believe you can go directly from the dmp file to a sql schema but
you should be able to use DTS to get you going. The doc will point you in
the right direction though.
--
Andrew J. Kelly
SQL Server MVP
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:una9y6abDHA.2476@.tk2msftngp13.phx.gbl...
> Oracle 9i to SQL 2K
> Can someone shed some light , how can I create SQL server db objects from
> the dmp file (export from Oracle).
> I need to create the schema and later load data in SQL SERVER..
> Any links or related topics will be highly appreciated.
> Thanks
> Sh
>
>

Oracle OBJECTs

Hello,

Has any one used object-oriented features of PL/SQL?

I know you can do something like the following.

CREATE TYPE employee AS OBJECT (...)

My biggest concern is performance: Do the objects in Oracle negatively affect performance? Anything else I should be aware of?

Thanks in advance,
EdwardHello Edward,

when you use TYPE for accessing or handling datas the performance will not change. Thats what we find out in our projects.
The benefit of using types is accesing complex datas very handy and often with one select.

Regards

Manfred Peter
(Alligator Company)
http://www.alligatorsql.com