OraFAQ Forum: Server Utilities » problem : import partition wise -- import has been done successfully withe now rows

Home » RDBMS Server » Server Utilities » problem : import partition wise -- import has been done successfully withe now rows (solaris 10 oracle 9.2.0.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem : import partition wise -- import has been done successfully withe now rows [message #321290]

Mon, 19 May 2008 15:17

skumar.dba
Messages: 82
Registered: October 2007

Member

experts,

i got a problem. i have done import from export dump. import got success.

my intension is to import data according partition wise. i took export according to partition wise.

please find the details:

{oracle}21% imp system/xxxxxx file=/opt/mis2/oracle/0406.dmp 
log=/opt/mis2/oracle/0406.log fromuser=txnmgr touser=kumar tables=txn:txn_0406 ignore=y

i am able to import 49999 records

when i check for table like this

SYSTEM> SELECT TABLE_NAME,PARTITION_NAME,NUM_ROWS FROM DBA_TAB_PARTITIONS
WHERE TABLE_OWNER='KUMAR' AND TABLE_NAME='TXN';

TXN           TXN_0306                                0
TXN           TXN_0307                                0
TXN           TXN_0405                                0
TXN           TXN_0406                                0
TXN           TXN_0407                                0
TXN           TXN_0505                                0
TXN           TXN_0506                                0
TXN           TXN_0507                                0
TXN           TXN_1206                                0
TXN           TXN_MAX                             49999

my import operation is went to another place. how do i resolve it.
can any one help to fix this issue.

[Updated on: Mon, 19 May 2008 15:31]

Report message to a moderator

Re: problem : import partition wise -- import has been done successfully withe now rows [message #321340 is a reply to message #321290]

Mon, 19 May 2008 23:33

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Your partitions might not be what what you think it is.

Regards
Michel

Report message to a moderator

Re: problem : import partition wise -- import has been done successfully withe now rows [message #321341 is a reply to message #321340]

Mon, 19 May 2008 23:49

skumar.dba
Messages: 82
Registered: October 2007

Member

Michel,

Thanks for reply. i am waiting from long time. i am also thinking that problem with partition. how do i find exact cause for this.

i created table based on ddl from source. means i took ddl for this table from the database where i took export.

at target side tablespace are different from source side.

one more question i have. the import i am executing is correct?

Report message to a moderator

Re: problem : import partition wise -- import has been done successfully withe now rows [message #321352 is a reply to message #321341]

Tue, 20 May 2008 00:48

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post log file of export and import.
Add HIGH_VALUE in your query of DBA_TAB_PARTITIONS to check with the source.
Extract DDL from both tables (source and target) using dbms_metadata.
...

Regards
Michel

Report message to a moderator

Re: problem : import partition wise -- import has been done successfully withe now rows [message #321919 is a reply to message #321352]

Wed, 21 May 2008 16:39

skumar.dba
Messages: 82
Registered: October 2007

Member

Michel,

please find the structure of partition at source and target sied
and also find export and import logs namely exp0406.log and import0406.log

at source side 

TXN        TXNMGR     TXN_0406   TO_DATE(' 2006-05-01 00:00:00', 'SYYYY-M    51220176
                                 M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

TXN        TXNMGR     TXN_0506   TO_DATE(' 2006-06-01 00:00:00', 'SYYYY-M    51370330

----
at target side 


TXN        KUMAR      TXN_0406   TO_DATE(' 2006-05-01 00:00:00', 'SYYYY-M           0
                                 M-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

my import statement is 
imp system/xxxxxx file=/opt/mis2/oracle/data/db2/exports/0406.dmp 
log=/opt/mis2/oracle/data/db2/exports/0406.log 
fromuser=txnmgr touser=kumar tables=txn:txn_0406 ignore=y

can you guide me where i am doing wrong?

Attachment: exp0406.log
(Size: 0.58KB, Downloaded 1191 times)

[Updated on: Wed, 21 May 2008 23:24] by Moderator

Report message to a moderator

Re: problem : import partition wise -- import has been done successfully withe now rows [message #321960 is a reply to message #321919]

Wed, 21 May 2008 23:23

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post import log.
Don't use num_rows, use couont(*)

Regards
Michel

Report message to a moderator

Previous Topic:	Backup Automation.
Next Topic:	export parameter clarificationsq

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 03:39:04 CDT 2024