OraFAQ Forum: Server Utilities » 9i data import to 10g

Home » RDBMS Server » Server Utilities » 9i data import to 10g (10.2.0.3)

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

9i data import to 10g [message #309408]

Thu, 27 March 2008 06:15

vipin
Messages: 40
Registered: May 2002

Member

Hi all,

We tried importing 9i dump to 10g database but the space usage is intrestingly high. A 9GB data is occupying 40GB in 10g. If you have encountered similar problems, please let me know.

Thanks,
vipin

Report message to a moderator

Re: 9i data import to 10g [message #309411 is a reply to message #309408]

Thu, 27 March 2008 06:24

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You use "compress=y" option (default value) and have minextents set or you have different tablespace settings or...

Regards
Michel

Report message to a moderator

Re: 9i data import to 10g [message #309431 is a reply to message #309411]

Thu, 27 March 2008 07:22

vipin
Messages: 40
Registered: May 2002

Member

Thanks Michael. It had a different Uniform extent size. As always appreciate your support. Have a great day!

Report message to a moderator

Previous Topic:	Import without dropping tables
Next Topic:	Problem whit nulls and sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 27 21:43:07 CST 2025