Home  >  Oracle Data Warehouse & Business Intelligence > Importing Source Data Structures (from an Oracle database)

Note: This article ( named Importing Source Data Structures from an Oracle database ) was taken from www.in-oracle.com.

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

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

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

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

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

From the summary screen, choose "Finish" button. 

You will see the following screen:

When the import is done you will see:

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):

Save this import :  Ctrl + S

Note: This article ( named Importing Source Data Structures from an Oracle database ) was taken from www.in-oracle.com.