Re: Creating scripts

Hi,

try:

%oracle_home%\bin\expXX.exe <usr>/<pwd> file=<path>\<file> grants=n rows=n owner=<usr> full=n

Bret schrieb:
>
> 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

--

Regards

Matthias Gresz :-)

Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Thu Oct 15 1998 - 05:40:03 CDT