Home » RDBMS Server » Server Utilities » export and import problem (oracle 10.2.0.3)
export and import problem [message #356173] Wed, 29 October 2008 17:03 Go to next message
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 #356175 is a reply to message #356173] Wed, 29 October 2008 17:24 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Actually what's your problem? I'm not seeing any error message in below logfile.

Babu
Re: export and import problem [message #356176 is a reply to message #356175] Wed, 29 October 2008 17:28 Go to previous messageGo to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
it did not import any records.
Re: export and import problem [message #356177 is a reply to message #356176] Wed, 29 October 2008 17:36 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Hello,

1. Post your export log file.
2. Please post which command your used for Import

Babu

Re: export and import problem [message #356178 is a reply to message #356177] Wed, 29 October 2008 17:42 Go to previous messageGo to next message
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 #356179 is a reply to message #356178] Wed, 29 October 2008 17:51 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Try to import using 9i import utility.

& also your 9i & 10g database character set both are different.

Babu
Re: export and import problem [message #356180 is a reply to message #356179] Wed, 29 October 2008 17:57 Go to previous messageGo to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
how do i use 9i import utility in 10g.

could you please provide more information.
Re: export and import problem [message #356181 is a reply to message #356180] Wed, 29 October 2008 18:04 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


1. From 9i database.

imp babu/babu@10gdatabase parfile=....

Or

2. Copy 9i import utility & paste in 10g oracle_home/bin (make sure please take 10g import utility backup)

Babu
Re: export and import problem [message #356182 is a reply to message #356181] Wed, 29 October 2008 18:08 Go to previous messageGo to next message
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 #356183 is a reply to message #356182] Wed, 29 October 2008 18:31 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
also your 9i & 10g database character set both are different.


I already told you it's too different database character set.

Babu
Re: export and import problem [message #356349 is a reply to message #356181] Thu, 30 October 2008 08:16 Go to previous messageGo to next message
joy_division
Messages: 4642
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 #356366 is a reply to message #356349] Thu, 30 October 2008 09:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Almost thought It was a joke Smile
Also in most cases, character set conversion will be taken care of automatically.
@OP
>>i don't have oracle 9i binaries on the host. so fist case is not possible for me.
Easiest thing is to install the same version client and do the import.
Else, you need to modify certain views in database so that it understand the other version.
Re: export and import problem [message #356537 is a reply to message #356173] Fri, 31 October 2008 01:21 Go to previous messageGo to next message
amardeep.sidhu
Messages: 7
Registered: October 2007
Junior Member
Firstly check is there any data in that particular partition in the source database ?

Also paste the complete contents of the import log.

Amardeep Sidhu
Re: export and import problem [message #381412 is a reply to message #356537] Fri, 16 January 2009 15:23 Go to previous messageGo to next message
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

Re: export and import problem [message #382028 is a reply to message #381412] Tue, 20 January 2009 13:32 Go to previous message
skumar.dba
Messages: 82
Registered: October 2007
Member
problem is cleared.

thanks for every one help

[Updated on: Tue, 20 January 2009 13:32]

Report message to a moderator

Previous Topic: exp compress
Next Topic: Import -Export
Goto Forum:
  


Current Time: Thu Dec 08 00:28:24 CST 2016

Total time taken to generate the page: 0.10137 seconds