Re: Creating scripts

There are no simple ways of getting all the tables and columns. It is possible to write SQL to extract in an intelligent manner this information but few of us have bothered to write or use it.

A good alternative is TechnoSolution SQLNavigator (about $600) which is a high end developer front end to Oracle. It has an extract DLL function embedded in it.

A second choice is TOAD. (Tool for Oracle Application Development , i think). It is freeware
available at www.toadsoft.com. It has many of these features. If all else fails you can open each
table and copy / paste the ifnormation out of the windows.

Happy hunting.

Mike Krolewski

Bret wrote:

> We have a client with an Oracle 7 database. I do not have access to the
> manuals, so forgive me if this question is very basic. I need to know if
> the following is possible, and generally how it is done so that I can
> present a solution to my team.
>
> Our client uses an Oracle database, and we need to build their table/index
> structure on our in-house, non-Oracle database. I need to know a command
> from Oracle that would produce a text script of all of a particular user's
> tables, indexes, stored procedures, triggers, etc, so that I can create the
> same structure in our database by running the script. I would also like to
> dump their data into a text file for importing into our database.
>
> Does the enterprise manager provide these functions? What about command
> line utilities? I appreciate any info provided.
>
> Bret
Received on Sat Oct 24 1998 - 16:40:37 CDT