Oracle 9i Tutorial : Drop,Rename and Truncate table

DROP TABLE

  Remove rows and a table structure.

  Once executed, this statement cannot be rolled   back.

  -DROP TABLE EMPLOYEE

RENAME

  Rename a table, view, sequence, or synonym.

  -RENAME EMPLOYEE TO EMPL;

TRUNCATE

  Remove all rows from a table and release the   storage space used by the table.

  The DELETE statement removes only rows.

  -TRUNCATE TABLE EMPLOYEE;