| Import IMP-00003 Error [message #153875] |
Wed, 04 January 2006 10:09  |
gjayasekar
Messages: 45
Registered: October 2005
|
Member |
|
|
Hi,
I am export file from 9.2.0 and import into 8.1.6
then i have got this error how to solve it
export details
1/5/2006 4:22:48 PM: User(jai@csqadb) exp file=c:\jai\nn.dmp tables=JAI.NN indexes=n
Export: Release 9.2.0.1.0 - Production on Thu Jan 5 16:22:49 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the OLAP option
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: indexes on tables will not be exported
About to export specified tables via Conventional Path ...
. . exporting table NN 50 rows exported
Export terminated successfully without warnings.
import error details
1/5/2006 4:25:00 PM: User(jai@oracle-dev) imp file=c:\jai\nn.dmp fromuser=jai touser=jai tables=nn commit=y show=y
Import: Release 9.2.0.1.0 - Production on Thu Jan 5 16:25:01 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully
Thanks
Jai
[Updated on: Thu, 05 January 2006 04:57] Report message to a moderator |
|
|
|
| Re: Import IMP-00003 Error [message #154300 is a reply to message #153875] |
Fri, 06 January 2006 11:51  |
DanielRey
Messages: 11
Registered: January 2006
Location: Mendoza, Argentina
|
Junior Member |
|
|
Hi Jai.
| Quote: |
I am export file from 9.2.0 and import into 8.1.6
|
You can´t. You should export from 9.2.0 using the 8.1.6 export utility, if you want to be able of import the dump file into an 8.1.6 rdbms.
Regards.
Daniel
|
|
|
|
|
|
| Re: Import IMP-00003 Error [message #154604 is a reply to message #153875] |
Mon, 09 January 2006 12:56 |
DanielRey
Messages: 11
Registered: January 2006
Location: Mendoza, Argentina
|
Junior Member |
|
|
Jai:
Configure the tnsnames.ora in the Machine 2 adding the connection descriptor for the Machine 1.
Example:
foo1 =
(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Machine1)(PORT = 1521)) ) (CONNECT_DATA=(SID=foo)(SERVER=DEDICATED)))
Some fileds may differ in your installation
From machine2 test it using:
sqlplus scoot/tigger@foo1
If you get connected the configuration was successfull.
From the machine2 prompt run the export utility and when prompt for the user name, type user@foo1
Regards
Daniel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
