Re: Creating scripts

There are a lot of factors that come into play here. It sounds to me like you have Oracle Client running which will allow you to use ODBC drivers to get that data into MS-Access. As far as the tables, yes, you can get all of that data into a text file (comma separated, or whatever). The way I would go about that (and have gone about this) is to import the table into MS-Access. Once you do this you can convert the Access table into a comma separated or fixed width file. Of course, with this, you would loose all your referential integrity constraints. There is a command that will allow you to create a text file of ALL this (triggers, procedures, indexes, etc.) called EXP which is short for export, but this will probably not work for what you are doing, because as far as I know the EXP is only for migrating data between different versions of Oracle. I would be surprised if there was something that converted all of that over to another database, especially the procedures.

Good luck, hope that helps a little
Kevin

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 Wed Oct 14 1998 - 10:26:29 CDT