Skip to main content

Doing an Oracle 11g database export to Oracle 10g remotely

Today one of our production Oracle 11g database server crashed due to some log file issue. I exported the data and tried to import to a test 10g server. The import didn't happen due to the dump file being in a new version. So i searched and found a solution. Thanks Google once again saving my day. Below are the steps to overcome that issue by remotely exporting the Oracle 11g database using the Oracle 10g export utility.

You need a tnsnames.ora file on the dump recipient server and add the remote 11g servers details and run the below command

exp
userid=system/system@dbname full=yes file=dumpfile.dmp

Only make shure that you use the same version of exp as is running on your server.
E.g. Never run exp from 10.1 versus a 10.2 database. Also you should use the same NLS_language setting.

Comments

Unknown said…
can you explain it more in detail?? how do I get the dump server, how do I know the versions? where do I run that command? thanks
Anil said…
Dear Diego...Din't understand what you meant. For getting the versions please do Googling.

Popular posts from this blog

Create Great looking diagrams - Gliffy.com

I was looking for an online diagram creating tool. Came across Gliffy.com where I could create actually great looking diagrams without much of learning curve. The tool is 1. Very easy to use 2. Has drag and drop of elements to your diagram 3. Collaboration (which I have not tested). 4. Works from anywhere on a browser with Internet connection (I used it in Google Chrome on Linux Mint 10) When you click on the "Try it now" a new screen will open as below. You can either create a blank page to create a diagram from scratch or select from a bunch of samples and work on them to create one for your requirement. There are options to export the diagrams you created to SVG, JPEG, PNG and XML format once you register for free on the website. Once you register you can save the diagrams that you created in the site itself and retrieve it at a later time by logging into the website. I made three diagrams and it was real easy and simple. The site has two kind of pa

Kerio Connect - SQLLite journal.db error

Today I noted that the Keio Connect mail server had thousands of error.log files with 75MB size filled up in the server. As always Google gave the answer. The error looks some what like below. [10/Aug/2011 10:49:35] SQLiteDbWriteCache.h: write_thread - file '/path/to/file/<user>/.journal.db', SQLite error: code 1, error SQLITE_ERROR[1]: no such table: journal_temp The solution is as below 1. Delete the cache from the client's workstation 2. Delete the profile 3. Stop the server 4. Go to the server and navigate through the user's store folder 5. Delete the .journal.db (for Linux it is  find . -name "FILE-TO-FIND"-exec rm -rf {} \; ) 6. Start the server 7. Create a new profile for the clients workstation With help from Kerio Forum Cyberciti