Re: Quick guide to importing/exporting database

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 - 16:19:34 CET