| exp 10.2 & imp 10.1 [message #176967] |
Mon, 12 June 2006 04:37  |
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
|
Senior Member |
|
|
Hi,
Is it possible to do an import to a 10.1 database from a file that was exported from a 10.2 database? i've tried and it fails giving the following error.
| Quote: |
IMP-00008: unrecognized statement in the export file:
|
Any workaround this?
thanks for your help
|
|
|
|
|
|
|
|
| Re: exp 10.2 & imp 10.1 [message #176979 is a reply to message #176967] |
Mon, 12 June 2006 05:09  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
to import into 10.1 database, the regular export utility of 10.2 database can not be used, you have to export , using export utility of 10.1 database.
See the docs at:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1013164
| Quote: |
The Import utility and the database to which data is being imported (the target database) must be the same version.
The version of the Export utility must be equal to the earliest version of the source or target database.
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.
|
check if you get this error after exporting the 10.2 db with 10.1 export utility.
|
|
|
|
| Re: exp 10.2 & imp 10.1 [message #176987 is a reply to message #176979] |
Mon, 12 June 2006 05:31 |
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
|
Senior Member |
|
|
Hi Guys,
Thanks for your help. i've tried what the document said but still no result. what i did was back up the 10.2 exp file in the $ORACLE_HOME/bin to exp.10.2 and copy the exp file from the 10.1 to the same location. then ran the usual exp tbx/tbx file=... command. it seems the utility is unable to connect to the database. what is that i'm doing wrong? please help
thank you.
|
|
|
|
|
|
| Re: exp 10.2 & imp 10.1 [message #176997 is a reply to message #176967] |
Mon, 12 June 2006 06:21 |
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
|
Senior Member |
|
|
Hi Guys,
Thank you for all the help. it's fine now. my 10.2 and 10.1 databases were on two different servers. so gave the tns name for the source db in the exp utility (exp tbx/tbx@newdb file=..)and now i'm exp/imp without any problem.
Cheers
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
