Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Toad and dmp file

Re: Toad and dmp file

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 12 Oct 2005 13:56:57 GMT
Message-ID: <Xns96ED46B7079D4SunnySD@68.6.19.6>


"Vilco" <a_at_b.invalid> wrote in
news:s653f.8999$Pe2.189433_at_twister2.libero.it:

> Mi e' parso che sybrandb_at_yahoo.com abbia scritto:
>

>> No version, no platform.
>> A dmp file doesn't contain the create database statement,
>> so you would need to use the database creation assistant

>
> Are you sure? I did some recovery of dumpfiles (DMP) by simply
> creating a new user/schema from management console and then
> running IMP.EXE to get the tables in the new schema, without any
> database creation assistant.

What happens if all you have is a *dmp file & NO functioning DB? What must be done before running imp? Received on Wed Oct 12 2005 - 08:56:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US