Home arrow Databases arrow Troubleshooting Import of Oracle Dump Files
Main Menu
Home
Help Docs
Newbies
Corporates
Gnu/Linux Distros
Programming
Databases
Links
Search
Regular
News
Interviews
Aaj Ka Tip
Aaj Ka Command
Community
Blogs
Wiki
Forums
Services
Free Software

Troubleshooting Import of Oracle Dump Files Print E-mail
A no. of errors are encountered while importing dump files in Oracle database.

Some of them are due to

1. Tablespace not found.
2. User/Role not found.
3. Incorrect database charset

If correct parameters are not provided to the person doing the import, it a more of HIT/TRIAL methdology.


A simple way out of these is to open the DMP files in any TEXT editor,preferably VI if on Gnu/Linux and trying to read inbetween lines to get some usefull info on the above issues.

Caution should be taken in
1. The dmp file if large will take time to load in the editor.
2. Do not edit the dump file in the editor, this might corrupt it, preferable maintain a backup of the dump file before opening it in the Editor.
< Previous   Next >



gnulinuxclub
Join Us
About Us
Contact Us
Support Us
Acknowlegdement
Login(only for dev.)

Royalty Free Images

O'Reilly User Group discount!




Powered By GIMP GIMP
Contact Webmaster Copyleft 2011 gnulinuxclub.org