After you have connected to a database, you can create, modify, and delete dimensional objects. You can have only one database connection open at a time.
To connect to a database:
Create a database connection if you have not done so already. In the navigation tree:
Right-click the Databases folder, then choose Add Database to Tree from the pop-up menu.
Complete the Add Database to Tree dialog box.
Click the plus icon (+) next to a database.
Complete the Connect to Database dialog box.
If you are already connected to a database, this operation automatically closes that connection.
Copyright © 2003, 2007, Oracle. All rights reserved.