Home » RDBMS Server » Server Utilities » problem : import partition wise -- import has been done successfully withe now rows (solaris 10 oracle 9.2.0.7)
problem : import partition wise -- import has been done successfully withe now rows [message #321290] Mon, 19 May 2008 15:17 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your partitions might not be what what you think it is.

Regards
Michel
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
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
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 messageGo to next message
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 179 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 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post import log.
Don't use num_rows, use couont(*)

Regards
Michel
Previous Topic: Backup Automation.
Next Topic: export parameter clarificationsq
Goto Forum:
  


Current Time: Wed Dec 07 10:33:40 CST 2016

Total time taken to generate the page: 0.14176 seconds