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: 65139
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: 65139
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: 65139
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: Fri Aug 18 02:02:33 CDT 2017

Total time taken to generate the page: 0.09155 seconds