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
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: 64132
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
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!
Previous Topic: Import without dropping tables
Next Topic: Problem whit nulls and sql loader
Goto Forum:
  


Current Time: Wed Dec 07 18:55:27 CST 2016

Total time taken to generate the page: 0.06113 seconds