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

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.


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 -

I was looking for an online diagram creating tool. Came across 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

Nodejs and NPM setup on Linux Mint

To install current version of Node js on Linux Mint or any Ubuntu derivatives 1. Install Node      $ curl -sL | sudo -E bash - 2. Check Node version     $ node -v         vxx.xx.x    $ npm -v         x.x.x 3. Verify the Node installation      var http = require('http');      http.createServer(function (req, res) {      res.writeHead(300, {'Content-Type': 'text/plain'});      res.end('Hello World...!!!');      }).listen(3001, "");      console.log('Server running at');     open your browser and type the URL    You can see the me ssage “Hello World…!!!” Source:  1. 2.

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