Database Export/Import

[RAD2000]

I have inherited a system with no documentation on the database and its structure. Is there a script I can run that will describe the tables, etc. We need to export this database from a Unix server and import it to NT.

Can anyone advise me about this? Thanks for any assistance.

[maachan]

If you have access to a tool like ERwin, you can reverse engineer the database and create entity relationship diagrams.

Otherwise,

-- Shows schema owners and how many of each object type they own
select owner, object_type, count(*) from dba_objects
group by owner, object_type;

That's a start.

Good luck

[pwoneill]

You can download free/evaluation copies of Toad ( [url]http://www.toadsoft.com[/url] ), EzSql ( [url]http://www.ezsql.net[/url] ) for browsers that you can just see all schemas and objects, or an evaluation copy of Embarcadero ER/Studio ( [url]http://www.embarcadero.com/products/Design/erdatasheet.htm[/url] ) to reverse engineer the database and get an ERD you can look at, if you don't have access to the full versions of either of the products.

As for moving from Unix to NT, export/import is probably the best way to go, start reading some docs and/or doing searches in this forum for some good info.