In Oracle : Import Source Data Structures from Oracle

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Import Source Data Structures from Oracle

 

 Import Source Data Structures from Oracle

 

 

Note: I have used Oracle Warehouse Builder 11.2.0.1

 

Start the Design Center

Start button -> All Programs -> Oracle 11g Installation (Name) -> Warehouse Builder -> Design Center

 

Import Source Data Structures from Oracle

 

You can see that there are no object in the ORACLE_MODULE1.

 

 

Import Source Data Structures from Oracle

 

 

Click Right  -> Choose Import  -> Database Objects ...

 

 

Import Source Data Structures from Oracle

 

Choose the objects (from the source database) to be imported. Click on "Next".

 

 

Import Source Data Structures from Oracle

 

Choose the objects to be imported / re-imported.  Click on "Next".

 

Import Source Data Structures from Oracle

 

From the summary screen, choose "Finish" button. 

 

You will see the following screen:

 

Import Source Data Structures from Oracle

 

When the import is done you will see:

 

Import Source Data Structures from Oracle

 

You probably will click on "OK" to make the import permanent.

 

If you click on the "OK" button, you will see the tables imported in the Oracle Warehouse Builder (Navigator):

 

Import Source Data Structures from Oracle

 

 

Save this import :  Ctrl + S

 

 

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Import Source Data Structures from Oracle

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.