Re: Newbie: trying to import and replace Data from Dump

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. Received on Fri Jun 11 2004 - 15:16:40 CDT