OraFAQ Forum: Server Utilities » export / import timing difference

Home » RDBMS Server » Server Utilities » export / import timing difference

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

export / import timing difference [message #321075]

Sun, 18 May 2008 23:58

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 ??

Report message to a moderator

Re: export / import timing difference [message #321076 is a reply to message #321075]

Sun, 18 May 2008 23:59

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

What you guess? Should they need same time?

Report message to a moderator

Re: export / import timing difference [message #321082 is a reply to message #321075]

Mon, 19 May 2008 00:40

Michel Cadot
Messages: 68651
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

Report message to a moderator

Re: export / import timing difference [message #321089 is a reply to message #321076]

Mon, 19 May 2008 01:10

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?

Report message to a moderator

Re: export / import timing difference [message #321095 is a reply to message #321089]

Mon, 19 May 2008 01:25

Michel Cadot
Messages: 68651
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

Report message to a moderator

Re: export / import timing difference [message #321106 is a reply to message #321095]

Mon, 19 May 2008 01:57

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 02:09:25 CDT 2024