Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> creating database from dmp files
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 - 08:56:07 CST