| export and import problem [message #356173] |
Wed, 29 October 2008 17:03  |
skumar.dba
Messages: 82
Registered: October 2007
|
Member |
|
|
experts,
i am facing problem with import. i have export dump file. i took export on one table which is in 9.2.0.7 and i am trying to import
in a table which is in 10.2.0.3 version.
please find the import log file. not sure how to fix this problme.
can any one help me to find the problem and whit is the fix for this.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
import done in UTF8 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
Import terminated successfully without warnings.
kumar
|
|
|
|
|
|
|
|
|
|
| Re: export and import problem [message #356178 is a reply to message #356177] |
Wed, 29 October 2008 17:42  |
skumar.dba
Messages: 82
Registered: October 2007
|
Member |
|
|
export log file:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
Note: constraints on tables will not be exported
About to export specified tables via Conventional Path ...
Current user changed to BILLING
. . exporting table TXN_BB
. . exporting partition TXN_BB_1105
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................
42457973 rows exported
Export terminated successfully without warnings.
import parameter file.
file=/opt/mis/oracle/work/dbmane/txnbb_1105.dmp
log =/opt/mis/oracle/work/dbname/imp_txnbb_1105.log
fromuser=billing
touser=billing_arch
tables=TXN_BB_20081029:txn_bb_1105
constraints=n
grants=n
rows=y
indexes=n
STATISTICS=none
FEEDBACK=10000
buffer=10000000
ignore=y
commit=y
[Updated on: Wed, 29 October 2008 17:43] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: export and import problem [message #356182 is a reply to message #356181] |
Wed, 29 October 2008 18:08 |
skumar.dba
Messages: 82
Registered: October 2007
|
Member |
|
|
i don't have oracle 9i binaries on the host. so fist case is not possible for me.
2 case:
regular exports will run on this host. so i can't do any thing to copy 9i utilities and paste it in to the home.
is there any alternative way to import it.
i believe problem with NLS_LANG parameter.
|
|
|
|
|
|
| Re: export and import problem [message #356349 is a reply to message #356181] |
Thu, 30 October 2008 08:16 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| gentlebabu wrote on Wed, 29 October 2008 19:04 |
2. Copy 9i import utility & paste in 10g oracle_home/bin (make sure please take 10g import utility backup)
|
What!?!?! This is an awful piece of advice.
|
|
|
|
|
|
|
|
| Re: export and import problem [message #381412 is a reply to message #356537] |
Fri, 16 January 2009 15:23 |
skumar.dba
Messages: 82
Registered: October 2007
|
Member |
|
|
yes on source table partition i have lot of data.
here is the log file and parameters i am using.
please advice me to fix this problem
nohup /opt/mis2/oracle/product/9.2.0.7/bin/imp system/2b1itzqb@BBQISRPT parfile=imp_txnbb_1105.par &
[1] 13749
BTQISPRD:genesse:{oracle}87%
Import: Release 9.2.0.7.0 - Production on Fri Jan 16 22:26:26 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
IMP-00057: Warning: Dump file may not contain data of all partitions of this table
IMP-00055: Warning: partition or subpartition "TXN_BB_20081029":"TXN_BB_1105" not found in export file
Import terminated successfully with warnings.
file=/opt/mis2/oracle/work/txn_bb_migration/txnbb_1105.dmp
log =/opt/mis2/oracle/work/txn_bb_migration/imp_txnbb_1105.log
fromuser=billing
touser=BILLING_ARCH
tables=TXN_BB_20081029:txn_bb_1105
constraints=n
grants=n
rows=y
indexes=n
STATISTICS=none
FEEDBACK=10000
buffer=10000000
ignore=y
commit=y
[Updated on: Fri, 16 January 2009 16:39] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
