Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: High Water Mark???

Re: High Water Mark???

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 07 May 2006 09:11:34 -0700
Message-ID: <1147018299.243830@bubbleator.drizzle.com>


Shahnaz wrote:
> Hi Friends,
> Please assist me what is high water mark in oracle 9i and how to remove
> this water mark?

<SARCASM>
To remove the high water mark just do the following:

SELECT table_name FROM dba_tables;

Then ...

DROP TABLE <table_name>;

for each of the offending tables.
</SARCASM>

Sorry for the sarcasm but what unearthly form of insanity would cause someone to ask how to drop something while in the exact same sentence asking what it is?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun May 07 2006 - 11:11:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US