Re:USER DUMP HOW?

From: <dgoulet_at_vicr.com>
Date: Thu, 10 Jan 2002 11:53:47 -0800
Message-ID: <F001.003ECF6D.20020110111109@fatcity.com>

Use the exp utility to create a dump file of the user but use the 'rows=n' option to speed matters up. Then use the imp utility with the 'indexfile=<filename.sql>' option. Now your left with this complete script of how the schema is created. All you have to do is remove the 'REM' from the beginning of any lines concerned with creating tables.

Dick Goulet

____________________Reply Separator____________________
Author: "Seema Singh" <oracledbam_at_hotmail.com>
Date:       1/10/2002 10:41 AM

Hi
Is there any way to take user dump which containts indexes,tables,constraints etc like "create table tablename ....... like".I don't want to use import option.Can I do thru export only or not? Thanks
-sEEMA

MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seema Singh
INET: oracledbam_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message