Re: oracle schema dump utility

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/06/08
Message-ID: <sZF%4.239690$Tn4.2173946@news1.rdc2.pa.home.com>#1/1

Oracle's exp utility.

exp system/manager full=y rows=n

imp system/manager full=y

There are two options that can be done with the import. indexfile=something.sql -- this just has table and index data. http://24.8.218.197/tools/dbasonly/#Indexfile

show=y log=something.sho -- this has all information, except the insert statements, but is difficult to read and use, but there are tools that allow you to use it.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"mcomer" <mcomer2NOmcSPAM_at_hotmail.com.invalid> wrote in message
news:1c620388.1257dc49_at_usw-ex0106-047.remarq.com...


> I am looking for any utilities that exists to dump the database

> schema - tables, indexes, constraints.

>

> Thanks,

> Marc

>

> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network

 *


> The fastest and easiest way to search and participate in Usenet - Free!

>

Received on Thu Jun 08 2000 - 00:00:00 CDT