Re: creating database from dmp files

Creating the database is directly is not doable. Not for any major technical reasons, if you were going to AIX, but because of the different platforms.

Indirectly doable:

1-Create a minimal database on the NT machine.

2-Using the Import73 utility, generate an INDEXFILE of the .dmp file structures. This file is editable.
(FULL=Y,ROWS=N,INDEXFILE={whatever}_

3-Edit the indexfile from (2). You should see create tablespace commands that specify file names. It is these file names that you must change. NT doesn't use the same nameing convention. It will also tell you what users need to be created (schema owners, etc.)

4-Run the create script from (3). This will create the structures (tablespaces,tables,indexes,etc.)

5-Run the imp73 with the original .dmp file.

If the indexfile does not show the create tablespace DDL, it will at least give you the name of the tablespaces to be created as sort of step 4a.

Also, you might want to FTP the .dmp from the AIX to the NT in binary mode, depending on the readability of the cd.

Enjoy.

"P. Bianchi" <ppbianchiNOSPAM_at_virgilio.it> wrote in message news:<3C42F187.1B9525B_at_virgilio.it>...
> Or departmental info system runs under Oracle 7.3 on a small AIX server
> which is always short on disk space (2 GB). Therefore every two months
> we are forced to dismiss some older data, by exporting them to a dmp
> file. We dump the data from a Windows workstation, by invoking an
> "exp73.exe" utility which creates *.dmp files on the workstation.
> Exported files (avg size 100 MB) can then be archived, stored on CDROM
> etc.
>
> Should we need to examine data contained in those *.dmp files, we could
> reload them into a temporary portion of our database, by means of an
> import utility. Importing however is painstakingly slow and we no
> longer use it.
>
> We now have the opportunity of putting the exported data on another
> windows workstation with plenty of disk space, where Personal Oracle 73
> is installed. I therefore would like to re-create a reduced copy of our
> database, running under Personal Oracle 73, where to import the dumped
> data into, and where to leave them forever, as long as disk will allow.
>
> I have the *.dmp files, I can see from a log file which tables should
> reside into them, I have no immediate infos at the structure of those
> tables.
>
> Can I "create a database right from dump file"? And generally speaking,
> how should I proceed for importing such files on a Personal Oracle
> system?
>
> Thanks in advance
> P. Bianchi
Received on Mon Jan 14 2002 - 14:26:08 CST