problem : import partition wise -- import has been done successfully withe now rows [message #321290] |
Mon, 19 May 2008 15:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #321919 is a reply to message #321352] |
Wed, 21 May 2008 16:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 1261 times)
[Updated on: Wed, 21 May 2008 23:24] by Moderator Report message to a moderator
|
|
|
|