Re: Quick guide to importing/exporting database

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Mar 2004 07:19:34 -0800
Message-ID: <2687bb95.0403100719.59dbb45@posting.google.com>

kevin_at_mc-ginley.com (Kevin McGinley) wrote in message news:<bee8ea7f.0403090712.117cdcf6_at_posting.google.com>...
> Hello, as my knowledge of Oracle is basically zero I was hoping
> someone here could give as concise an answer to the following problem.
> I need to create a copy of an exported database schema as a new
> database on the same server. I already have the export file and was
> wondering how to import this as a new schema ?

See the Utilities Manual for imp and look at FROMUSER and TOUSER parameters.

imp file=xxx.dmp fromuser=olduser touser=newuser ....

HTH -- Mark D Powell -- Received on Wed Mar 10 2004 - 09:19:34 CST