Home » RDBMS Server » Server Utilities » 9i data import to 10g (10.2.0.3)
9i data import to 10g [message #309408] Thu, 27 March 2008 06:15 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68652
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 04:57:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.