I have a full Oracle DMP file, but no Oracle db, and I need to extract the table data from the DMP file.
(I got the DMP file, and the under development app that I was woking on from my last employer as a settlement when he failed to live up to our contract. He also promised the Oracle licence but he never delivered the CDs.)
Is there a tool or preferably a service that can extract the data for me?
I have written a VB program to parse the file and extract the data but I can not determine the format of the numeric data. Some numeric data is 1 byte, some 2 bytes, some 3 bytes and some 4 bytes and stored in some binary format. In some columns I know what the numeric value of the data is but still can not determine how to extract that from the binary data. Determing how to read this data would be the best solution for me.
The following info is from the EXP log file:
Connected to: Oracle8i Enterprise Edition Release 22.214.171.124.0 - Production
With the Partitioning and Java options
PL/SQL Release 126.96.36.199.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
I downloaded the Oracle 8i Personal edition for Win 2k (nt817personal.zip). I unziped the file and copied the contents to a CD.
The install software will not run!!! The autorun menu comes up but clicking on the install/uninstall option does nothing. I tried running both the install program in the cd root and the setup program in the \install\win32 folder from both the cd and the hard drive. The hour glass twirls for a few seconds then the program dies with no indication of why.
Question: Why is installing Oracle software like pulling teeth?
Answer: Because you can't do it without professional help!
Conclusion: Its no wonder why Oracle can't compete with MS SQL Server on the low end. The average user can install SQL Server, but it takes a patient expert to install Oracle!
This problem sound familiar, this is an issue with the installer version and windows and the cpu model. Try these steps:
1. Copy the contents of the \install directory to a directory on your hard disk.
2. Search for all copies of the 'symcjit.dll' file both in and under the directory from Step 1, and rename them to 'symcjit.old'.
3. Navigate to your new install directory, and edit the 'oraparam.ini' file. You will probably have to change the permissions on the file first.
4. Change the JRE_MEMORY_OPTIONS parameter to: JRE_MEMORY_OPTIONS=-nojit -ms64m -mx128m
5. Save the file.
6. Run the setup.exe program in the win32 subdirectory.
This DMP was a FULL dump, see EXP command line in earlier message.
1. I made the DMP using my personal admin account. Should I set up a personal admin account to do the IMPort? Or can I use SYS or SYSTEM and if so, which? (There are commands in the DMP to create the user I used to create the DMP.)
2. Is there anything else I should set up before I execute the IMPort?
if you have a FULL export, please use the user SYSTEM to import it. (never use SYS to do an export or import!)
just make sure you have created the same tablespaces as in the source-DB, or oracle will try to create these tablespaces using the same path and filenames as there. this might not be desired.
If you have precreated the tablespaces, use the parameter IGNORE=y to tell the import just to skipp errors and not fail at the first error.
Have a look at the logfile afterwards to check if you have imported all objects you want.
Since I was after the table data the first thing I did was write a VB program and dumped all the table data to XML files. Now, if I lose the database I can read the data, including the numbers, from my XML files!