Re: Full Ex/Im-port to New Instance, NT

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 9 Oct 1998 15:12:02 -0500
Message-ID: <6vlqmi$6c4$1@garnet.tc.umn.edu>

You can try a filter on the 'imp show=y' output to get the SQL from an export file.

         http://www.tc.umn.edu/~hause011/ Is where I have a filter to do this.

This will give you the rest of the DDL (triggerz, pl/sql, grants, roles...)

You usually want to create data objects like users, grants, sequences, tables ... first, then add indexes and referential integrity constraints last. good luk.
--  

---

Steven Hauser, hause011_at_tc.umn.edu

Phone: (612)626-7135
Fax:   (612)625-6853


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

Received on Fri Oct 09 1998 - 15:12:02 CDT