---------------------------
----- Test SQL Script -----
---------------------------

  1  SELECT version
  2*   FROM v$instance

VERSION
-----------------
8.1.7.2.0


  1* DROP TABLE oracle.bobtest
DROP TABLE oracle.bobtest
                  *
ERROR at line 1:
ORA-00942: table or view does not exist 


  1  CREATE TABLE oracle.bobtest
  2*   ( junk VARCHAR(1) )

Table created.


  1  INSERT INTO oracle.bobtest
  2*   VALUES ( 'A' )

1 row created.

1 row created.

1 row created.


  1* COMMIT

Commit complete.


  1  SELECT COUNT(*)
  2*   FROM oracle.bobtest

  COUNT(*)             
---------- 
         3           


  1  ANALYZE TABLE oracle.bobtest
  2*   COMPUTE STATISTICS

Table analyzed.


  1  SELECT COUNT(*)
  2*   FROM oracle.bobtest

  COUNT(*)             
----------
         3           


  1  ANALYZE TABLE oracle.bobtest
  2*   DELETE STATISTICS

Table analyzed.


  1  SELECT COUNT(*)
  2*   FROM oracle.bobtest

  COUNT(*)             
----------
         3           


  1  ANALYZE TABLE oracle.bobtest
  2*   ESTIMATE STATISTICS SAMPLE 20 PERCENT

Table analyzed.


  1  SELECT COUNT(*)
  2*   FROM oracle.bobtest

  COUNT(*)             
----------
         3           


  1* DROP TABLE oracle.bobtest

Table dropped.