Re: Export of logical data model

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:<40c422de$1_at_olaf.komtel.net>...
> 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.

If you have Oracle support, see Note: 90449.1

There are plenty of scripts floating about on the net to do this, as well as several books.

Be sure and post minimal information for people to give you correct responses: http://members.cox.net/oracleunix/readme-cdos.htm

>
> 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...

grep and sed are pretty cool for this sort of thing, if you are going to do it more than once.

jg

--
@home.com is bogus.
http://quote.bloomberg.com/apps/news?pid=10000103&sid=a8yRk1nepHpM&refer=news_index