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: Table defragmentation/resizing question: Is this dangerous ?

Re: Table defragmentation/resizing question: Is this dangerous ?

From: Guy Dallaire <gdallair_at_criq.qc.ca>
Date: Tue, 18 Jan 2000 19:26:17 GMT
Message-ID: <3884bdd2.90402293@news.risq.qc.ca>


On Mon, 17 Jan 2000 20:28:02 GMT, gdallair_at_criq.qc.ca (Guy Dallaire) wrote:

>Suddenly, I'm starting to doubt about a procedure used here:
>
>- On a production database, table A goes to its MAX EXTENT REACHED
>
>Resolution:
>
>- The DBA exports the table with export (CONSISTENT=Y)
>- The DBA drops the table (Or truncates and adjust storage)
>- The DBA re-imports the table
>
>Is this OK or should I arrange for ALL USERS to exit and prevent them
>to connect during this intervention ?
>
>If the DBA permits the users to connect whil fixing the problem, while
>the table is dropped and while it is in the process of being reloaded,
>I wonder what happens if users are hitting the table (inserting or
>deleting in it).
>
>Isn't the integrity of the data compromised ?
>
>
>Thanks

Please not that my question is not wheter it is useful or not to defrag this table, but wether or not doing so while users are connected is dangerous.

I cant put an UNLIMITED extents to this table because I'm running 7.3.4 Received on Tue Jan 18 2000 - 13:26:17 CST

Original text of this message

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