Developer Tools
Warehouse Builder
 |
Oracle Warehouse Builder FAQ |
10g Release
| What versions of Oracle database can I use with Warehouse Builder 10g? |
For the target database, users can use Oracle 8.1.7, 9.2 and 10g with Warehouse Builder 10g. As a source, Warehouse Builder 10g supports:
|
| Top of Page |
| Can I use Warehouse Builder 9.2 with Oracle 10g database? |
| You can only use Oracle 10g database with Warehouse Builder 9.2 to store the design or run-time repositories. Because OWB 9.2 does not have a 10g location, you can not use an Oracle 10g source or target. If you are sourcing from or targeting Oracle 10g database you must use OWB 10g. |
| Top of Page |
| What platforms will Warehouse Builder 10g be available on? |
Warehouse Builder 10g will be available on all platforms that Oracle Database 10g is available on, with the the exceptions of HP OpenVMS and IBM zOS (OS/390). Specifically, Warehouse Builder 10g will be available on the following platforms:
Starting with Warehouse Builder 10g Release 1, Warehouse Builder will not be available on Sun Solaris (SPARC) 32-bit operating system, and will only support a database running on the Sun Solaris (SPARC) 32-bit operating system as a remote source. Customers that wish to continue to use a database running on this operating system in conjuction with any other Warehouse Builder functionality, must remain on Warehouse Builder 9.2 (or earlier). |
| Top of Page |
| Where can I download Warehouse Builder 10g? |
| Warehouse Builder 10g is available for download from Oracle Technology Network
http://otn.oracle.com/software/products/warehouse/index.html |
| Top of Page |
| What new features are introduced in Warehouse Builder 10g? |
|
The primary function of Warehouse Builder 10g is to support the Oracle Database 10g . Other changes in this release are:
More details on these changes are in Release Notes http://otn.oracle.com/documentation/warehouse.html Significant number of new features will be offered in the next release of Warehouse Builder which is currently scheduled to be available in November 2004.
|
| Top of Page |
| Does Warehouse Builder 10g leverage any new Oracle 10g database features? |
| While Warehouse Builder 10g supports Oracle Database 10g as a target database, it only implicitly leverages the new database features. The next release of Warehouse Builder will explicitly leverage many new Oracle Database 10g features. |
| Top of Page |
| When is the next feature bearing version of Warehouse Builder going to be released? |
| Warehouse Builder will offer significant number of new features in the next release of Warehouse Builder which is currently scheduled to be available in November 2004. |
| Top of Page |
| How should I install Warehouse Builder 10g? |
| Warehouse Builder 10g should be installed in its own Oracle home. For detailed installation instructions, please see Warehouse Builder Install and Configuration Guide http://otn.oracle.com/documentation/warehouse.html. |
| Top of Page |
| What CD pack is Warehouse Builder 10g located in? |
| Warehouse Builder 10g is a stand alone CD in the Oracle Developer Suite 10g (9.0.4) CD pack. This CD pack can be ordered through the OracleStore http://www.oracle.com/products/buy/ |
| Top of Page |
| Why should I upgrade to Warehouse Builder 10g? |
|
Warehouse Builder users will want to upgrade to Warehouse Builder 10g for the following reasons:
|
| Top of Page |
| I already have an existing data warehouse built with Warehouse Builder. How do I migrate to Warehouse Builder 10g? |
| For Warehouse Builder 3i, 9.0.2 and 9.0.3 users, you will need to upgrade your design and runtime environments. For Warehouse Builder 9.0.4 and 9.2 users, you can perform an in-place migration using a script to upgrade both your design time and runtime repositories. See the Warehouse Builder Install and Configuration Guide http://otn.oracle.com/documentation/warehouse.html, Chapter 3: "Upgrading to 10g Release 1 (10.1) and Migrating Data", for details. Note that additional steps are required if you perform a database upgrade as well as a Warehouse Builder upgrade. |
| Top of Page |
| What does it cost to upgrade to Warehouse Builder 10g? |
| Warehouse Builder users who have maintained their Oracle Developer Suite software update license are eligible to upgrade to Warehouse Builder 10g without any additional charges. Other users need to purchase an Oracle Developer Suite license. For questions about licensing, please contact your Account Manager. |
| Top of Page |
| What license do I need to use Warehouse Builder 10g? |
| Users need an Oracle Developer Suite license and an Oracle database Enterprise Edition license to run Warehouse Builder 10g. |
| Top of Page |
Printer View