Home » RDBMS Server » Server Administration » Best way to upload data to a warehouse
Best way to upload data to a warehouse [message #246513] Thu, 21 June 2007 03:21 Go to next message
guyj
Messages: 31
Registered: September 2005
Member
Hi All,

We have a Oracle 9i database and a Oracle 10g Warehouse. Now we need to upload data from 9i database to 10g warehouse daily but only for some tables. 9i database is running on Solaris and warehouse is on HP-UX.

Please advice me on possible ways to upload data from 9i database to 10g warehouse.

Thanks.
Re: Best way to upload data to a warehouse [message #246527 is a reply to message #246513] Thu, 21 June 2007 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
snapshot / materialized view.

Regards
Michel
Re: Best way to upload data to a warehouse [message #246529 is a reply to message #246527] Thu, 21 June 2007 04:01 Go to previous messageGo to next message
guyj
Messages: 31
Registered: September 2005
Member
Thanks Michel but we faced performance and locking issues with materialized views.
Re: Best way to upload data to a warehouse [message #246537 is a reply to message #246529] Thu, 21 June 2007 04:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which ones?

Regards
Michel
Re: Best way to upload data to a warehouse [message #246540 is a reply to message #246537] Thu, 21 June 2007 04:23 Go to previous messageGo to next message
guyj
Messages: 31
Registered: September 2005
Member
materialized view....
Re: Best way to upload data to a warehouse [message #246541 is a reply to message #246540] Thu, 21 June 2007 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I meant:
"locking issues" - which ones?
"performance issues" - compare to what?

Regards
Michel
Re: Best way to upload data to a warehouse [message #246542 is a reply to message #246541] Thu, 21 June 2007 04:45 Go to previous message
guyj
Messages: 31
Registered: September 2005
Member
mainly deadlocks... and this 9i database is a three node cluster...
Previous Topic: auditing the version of the client
Next Topic: Oracle 10g R2 for Redhat AS 4
Goto Forum:
  


Current Time: Tue Dec 06 10:12:40 CST 2016

Total time taken to generate the page: 0.14612 seconds