Can i import from 9i to 10g

Question: I need to export data from 10g and import it into 8i and 9i? How can I export from a later release and import it into an earlier release of Oracle? Answer: While there is never a guarantee that an later release expdp dmp file will import into an earlier release of Oracle this is called? In general, there was a major change between the older export utility exp and the data pump export expdp , and Oracle notes that exports from newer releases cannot be imported into earlier releases:.

For example, to create an export file for an import into a later release database, use a version of the Export utility that is equal to the source database. Conversely, to create an export file for an import into an earlier release database, use a version of the Export utility that is equal to the version of the target database. Ok so now, lets not trouble Allison for that, I will explain it: Consider an environment — U have 9i database in 1 box, and 10g on other.

So export from 9i db using exp utility of 9i and import into 10g using impdp. Thats it. Ur problem will get solved. There lots on the web for that.

To import the 10g dump to a 9i DB, you will have to install the 10g client with the db utilities and use the export utility from that home to import into the 9i home. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account.

We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. September 21, by samadhan. Back to work after long time, was busy in trekking. And also the 10g parameter properly set. Query to check Tablespaces and there sizes. Now run this tablespace. Recompile for invalid objects run utrp. I Hope this article helped to you.

It will help to motivate me to write more articles….!!!! Posted in Administration Tagged export , import , migration from 9i to 10g 3 Comments. Hi sam, First of all thanks for posting good articals, Please can u share errors and solutions in above migrataion project. Thanks for advance. Comments RSS. You are commenting using your WordPress.

You are commenting using your Google account.