| UNDO problem [message #160048] |
Thu, 23 February 2006 00:00  |
mahesh.vadamudula
Messages: 7
Registered: February 2006
Location: vizag
|
Junior Member |
|
|
Hi all,
Please Help me. I am working in a distributed database Envronment. From India i am able to connect to US database.
In the remote database i've table with 45 lakh records and i need to populate that table in my local database.
What i've done is that i've taken a logical exp and iam importing. But my question is that,what should be the Ideal size
for UNDO tablespace before i start importing.
Waiting For a sincere reply,
Regards,
Mahi
|
|
|
|
|
|
| Re: UNDO problem [message #160504 is a reply to message #160121] |
Mon, 27 February 2006 00:54  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Mahesh
1 small clarification sought:
Be default Commit=N [..Right..]
In such scenario, Import commits after importing every table.
If commit=Y is set, Import commits after importing each array of rows & not individual rows[size of array depending on buffer size]
Am I right in saying this?
--Girish
[Updated on: Mon, 27 February 2006 00:54] Report message to a moderator |
|
|
|
| Re: UNDO problem [message #160584 is a reply to message #160504] |
Mon, 27 February 2006 07:17 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Be default Commit=N [..Right..]
>>In such scenario, Import commits after importing every table.
Girish,
You are right and that was a grand-time misinformation from me.
Thanks for pointing.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
