Home » RDBMS Server » Server Utilities » export / import timing difference
export / import timing difference [message #321075] Sun, 18 May 2008 23:58 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi all,

i exported a table from database 'A' which took just 15 min .but when i imported the same table to database 'B' it took 40 minutes to import the table. can anybody come up with the solution ??

Re: export / import timing difference [message #321076 is a reply to message #321075] Sun, 18 May 2008 23:59 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What you guess? Should they need same time?
Re: export / import timing difference [message #321082 is a reply to message #321075] Mon, 19 May 2008 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No solution, it always takes more to write than to read, don't you think?

Regards
Michel
Re: export / import timing difference [message #321089 is a reply to message #321076] Mon, 19 May 2008 01:10 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

no.i am just asking u, y it shows much difference when importing the same table when it can take just 15 minutes to export the same table?
Re: export / import timing difference [message #321095 is a reply to message #321089] Mon, 19 May 2008 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it always takes more to write than to read

Try to understand why.

Regards
Michel
Re: export / import timing difference [message #321106 is a reply to message #321095] Mon, 19 May 2008 01:57 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

i just asked u question regarding the import na d export timing diffreence and replied me with the answer . i didnot not disagree with your answer. i agreed to your answer.

anyway thanks for the reply and answer.
Previous Topic: export table based on query and partition wise
Next Topic: exp-00003 no storage definition found for the segment (7, 255)
Goto Forum:
  


Current Time: Wed Dec 07 18:41:39 CST 2016

Total time taken to generate the page: 0.12062 seconds