johnbhurley_at_sbcglobal.net (John Hurley) wrote in message news:<d4d6f278.0406111216.6a582a9c_at_posting.google.com>...
> If you really have a complete export of all the stuff from the user
> schema that you need, the easiest thing to do is to drop the
> user/schema (drop user xxx cascade), recreate the user/schema (create
> user blah identifed by default tablespace blah temp tablespace), grant
> permissions necessary to the user (roles / and perhaps quotas) ...
> then import fromuser touser.
thank you, i think, that'll do. In DB2 (Unix/Win) i can use a
CREATE/REPLACE Option while importing data. On the other hand, i bet,
it would also drop the table and recreate it. Also thanks to Frank for
pointing me to an online documentation :-)
Received on Sun Jun 13 2004 - 12:13:47 CDT
