12
Lesson 11: Tasks on completion of the tutorial

Lesson 11: Tasks on completion of the tutorial

Congratulations! You have just completed the Oracle9i Discoverer Administrator tutorial. By now, you should have a solid understanding of the major features of Oracle9i Discoverer Administrator and how it affects every aspect of an end users view of database information through business areas.

You have learned that you can use Oracle9i Discoverer Administrator to help end users make much more effective use of database information by creating business areas that reflect their view of data, and simplify their tasks by creating conditions and joins they will need to use in worksheets.

In this tutorial you created your own unique tutorial database user, an EUL, a business area and a summary folder. You can now delete all of these objects from the database.

In this lesson you will remove all of the work that you completed a part of the tutorial.

In order to remove all of the work that you completed as part of this tutorial you must complete the following exercises:

• "Exercise 1: Deleting summary folders from the business area"

• "Exercise 2: Deleting the New Video Stores business area"

• "Exercise 3: Deleting the EUL owned by the tutorial database user"

• "Exercise 4: Deleting the tutorial database user from the database"

Exercise 1: Deleting summary folders from the business area

To delete summary folders from the business area:

1. Display the Workarea: Summaries tab

   Before Discoverer allows you to delete the New Video Stores business area, you must delete any summary folders you created in Lesson 10.

2. Select all summary folders in the New Video Stores business area.

3. Choose Edit | Delete to display the Confirm Delete dialog.

4. Click Yes to delete summary folders that you created as part of the tutorial.

You can now delete the New Video Stores business area.

Exercise 2: Deleting the New Video Stores business area

To delete the New Video Stores business area:

1. Display the Workarea: Data tab and click the New Video Stores business area.

2. Choose Edit | Delete to display the Confirm Business Area Delete dialog.

Figure 12-1 Confirm Business Area Delete dialog

Text description of the illustration badel.gif

3. Select the Delete this Business Area and its Folders radio button.

4. Click Yes to delete the New Video Stores business area.

Exercise 3: Deleting the EUL owned by the tutorial database user

To delete the EUL owned by your tutorial database user:

1. Choose Tools | EUL Manager to display the EUL Manager dialog.

2. Click Delete an EUL to display the Delete EUL dialog.

Note: Make sure that the EUL displayed in the EUL field is the same as your tutorial database user name. If it is not, reconnect to Discoverer using your tutorial database username and password and repeat steps 1 and 2.

3. Click OK.

   Discoverer displays a warning dialog.

4. Click Yes to delete the EUL owned by your tutorial database user.

   Discoverer displays the Commit Status dialog.

5. Click OK when Discoverer displays The EUL has been successfully deleted dialog.

You have now deleted all of the work that you have done as part of this tutorial from the EUL. You must now remove your tutorial database user from the database.

Exercise 4: Deleting the tutorial database user from the database

To delete your tutorial database user from the database:

1. Start SQL*Plus.

   For more information about SQL*Plus, see your database administrator.

2. Connect to the database using a database username and password that has DBA privileges.

3. Type the following SQL at the SQL> prompt:

   SQL> drop user admintutor(your initials) cascade;
   
   

4. Type the following SQL at the SQL> prompt:

   SQL> commit;
   
   

SQL*Plus deletes your tutorial database user from the database and displays the message:

User dropped

You have now deleted all of the work that you have built up as part of this tutorial from the EUL.

For more information regarding any Discoverer Administrator feature, click Help.

Lesson summary

In this lesson you removed all of the work that you completed as part of this tutorial by:

• deleting summary folders from the business area

• deleting the New Video Stores business area

• deleting the EUL owned by the tutorial database user

• deleting the tutorial database user from the database