OraFAQ Forum: Server Utilities » Export tables and data from 8192(Block Size) to 4096(Block Size) database

Home » RDBMS Server » Server Utilities » Export tables and data from 8192(Block Size) to 4096(Block Size) database

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

Export tables and data from 8192(Block Size) to 4096(Block Size) database [message #250423]

Tue, 10 July 2007 00:45

somavamshi
Messages: 17
Registered: July 2007
Location: bangalore

Junior Member

Hi ...........every one..

I have a doubt that We have two databases, one with 8192 and another with 4096 Block Size.
I want to export tables and data from 8192 to 4096 database.

1) Is this possible?
2) Will it export the New tables with data and data in to the existing tables?
3) What is the impact later?
4) Is there any block size error : Block size not found?

Kindly send me the results for the above questions.

YOurS

Soma

Report message to a moderator

Re: Export tables and data from 8192(Block Size) to 4096(Block Size) database [message #250426 is a reply to message #250423]

Tue, 10 July 2007 00:50

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1) Yes.
2) Yes.
3) Don't understand the question
4) Exp/imp don't care about block size

Regards
Michel

Report message to a moderator

Re: Export tables and data from 8192(Block Size) to 4096(Block Size) database [message #250432 is a reply to message #250426]

Tue, 10 July 2007 00:57

somavamshi
Messages: 17
Registered: July 2007
Location: bangalore

Junior Member

Thanks for your quick response. appreciated.

3) You can ignore this question.

1,2,4 are ok good,

Report message to a moderator

Re: Export tables and data from 8192(Block Size) to 4096(Block Size) database [message #250434 is a reply to message #250423]

Tue, 10 July 2007 00:59

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

Senior Member

Answer of question 4 solves answer of question3.

No Impact...

Report message to a moderator

Previous Topic:	Unique Index
Next Topic:	Copy command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 21:30:56 CDT 2024