Oracle DBA FAQ - Managing Oracle Database Tables

A collection of 17 FAQs on database tables for DBA and developers. Clear answers are provided together with tutorial exercises to help beginners on creating, altering and removing tables, adding, altering and removing columns, and working with recycle bin.

1. What Is a Database Table?
2. How Many Types of Tables Supported by Oracle?
3. How To Create a New Table in Your Schema?
4. How To Create a New Table by Selecting Rows from Another Table?
5. How To Rename an Existing Table?
6. How To Drop an Existing Table?
7. How To Add a New Column to an Existing Table?
8. How To Add a New Column to an Existing Table with a Default Value?
9. How To Rename a Column in an Existing Table?
10. How To Delete a Column in an Existing Table?
11. How To Recover a Dropped Table?
12. What Is a Recycle Bin?
13. How To Turn On or Off Recycle Bin for the Instance?
14. How To View the Dropped Tables in Your Recycle Bin?
15. How To Empty Your Recycle Bin?
16. How To Turn On or Off Recycle Bin for the Session?
17. How To List All Tables in Your Schema?

----->Answers