Export of logical data model

Hi everyone,

  how can I export from an Oracle Schema the logical data model (preferrable as a SQL script) so that I can feed it into another database management system, for example MS Access or MS SQL Server ? I would like to emphasize the "logical" part here, because the physical details (tablespaces, pctfree, ....) would not be understood by the other DBMS. So with "logical" I mean tables, indexes, constraints, views. Stored procedures and sequences are considered optional because in my special case there arent so many of those and there are different ways of doing those in other systems.

  I am aware that what ever I get created I would have to post process, maybe even manually (for example because data typed might be named differently, sets of reserved words do not match totally and so on...), but my main problem is how to get such a script or similar initially so that I got something to start from...

AH
:) Received on Mon Jun 07 2004 - 03:10:05 CDT