newbe question: how to... open database

EricW

unread,

May 21, 2008, 3:37:05 AM5/21/08

to

From a company we recieved a oracle database (version 8.0.6) on a CD
containing the following files:
AO_data01.dbf
RBS01.DBF
SYSTEM01.dbf
TEMP01.DBF
USERS01.DBF
CNTRL01.CTL
CNTRL02.CTL
ROMA_RN01A.LOG
ROMA_RN01B.LOG
ROMA_RN02A.LOG
ROMA_RN02B.LOG
ROMA_RN03A.LOG
ROMA_RN03B.LOG

I have installed Oracle 10 on my computer, but I cannot find how I can open
or import this database.

anyone who can/wants to help me?

rg,
Eric

Mladen Gogala

unread,

May 21, 2008, 4:19:51 AM5/21/08

to

To make a long story short, this will be an interesting exercise. Looking
at the case of your file names, this DB is from some kind of MS platform.
You will have to set a new home so that control files can be used to
locate the original files. I surmise you will have to use something like
"strings" command in order to hack the control files. As soon as you get
it set up properly, you will have to use DBUA. It's not a cross-platform
tool, so you better be on Winduhs yourself. You will also need a
parameter file. If all of this is on a single CD, ask the person who has
sent you the CD to export the database into a .dmp file and send it to
you. It will save you a major headache.

--
Mladen Gogala
http://mgogala.freehostia.com

EricW

unread,

May 21, 2008, 4:45:59 AM5/21/08

to

Thank you for your answer.

I do have this file too: Full_Export_Roma_RN.DMP

So how do I use this?
It's about 5 Mb in size.

rg,
Eric

"Mladen Gogala" <mgo...@yahoo.com> schreef in bericht
news:4833db27$0$30633$834e...@reader.greatnowhere.com...

Mladen Gogala

unread,

May 21, 2008, 6:37:51 AM5/21/08

to

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

EricW

unread,

May 21, 2008, 6:58:04 AM5/21/08

to

thank you

"Mladen Gogala" <mgo...@yahoo.com> schreef in bericht

news:4833fb7f$0$30635$834e...@reader.greatnowhere.com...

gazzag

unread,

May 21, 2008, 7:21:16 AM5/21/08

to

On 21 May, 11:58, "EricW" <iem...@home.com> wrote:
> thank you
>
> "Mladen Gogala" <mgog...@yahoo.com> schreef in berichtnews:4833fb7f$0$30635$834e...@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