Re: newbe question: how to... open database

On 21 May, 11:58, "EricW" <iem..._at_home.com> wrote:
> thank you
>
> "Mladen Gogala" <mgog..._at_yahoo.com> schreef in berichtnews:4833fb7f$0$30635$834e42db_at_reader.greatnowhere.com...
>
>
>
> > On Wed, 21 May 2008 10:45:59 +0200, EricW wrote:
>
> >> I do have this file too: Full_Export_Roma_RN.DMP
>
> >> So how do I use this?
> >> It's about 5 Mb in size.
>
> > Manual is here:http://tinyurl.com/3wlgc4
>
> > --
> > Mladen Gogala
> >http://mgogala.freehostia.com- Hide quoted text -
>
> - Show quoted text -

Further to Mladen's post, you will essentially have to create a database to import that dumpfile into.

Once you have a database, run the import utility as follows:

imp system/<system_password> file=Full_Export_Roma_RN.DMP log=Full_Export_Roma_RN.log show=y

This will generate a file Full_Export_Roma_RN.log which will show you all the DDL and DML that Oracle will attempt to perform on the database when you eventually run the import for real.

Prior to doing so, you will need to pre-create the relevant schemas (CREATE USER) and any tablespaces that are referenced in the STORAGE clause of any object creation statements.

HTH -g Received on Wed May 21 2008 - 06:21:16 CDT