Re: alter table vs update all_tables

   I believe that rule #1 of DB Administration is DON'T MAKE CHANGES TO THE DATA DICTIONARY DIRECTLY!
  Why not get your sql this way instead:

SQL> spool alter_table_storage.sql
SQL> SELECT 'ALTER TABLE '''||TABLE_NAME||''' STORAGE (NEXT 100M PCTINCREASE 0);' from ALL_TABLES;
SQL> spool off

Greg Stark wrote in message
<877lgrp4dc.fsf_at_HSE-Montreal-ppp33976.qc.sympatico.ca>...
>
>Is it legal to just update all_table or all_indexes to change parameters
like
>next_extent or pct_increase?
>
>It would be far more convenient to update storage parameters en masse or
>automatically using simple sql than to construct alter statements and then
>execute them.
>
>I'm thinking of running something like this night if i'm sure it's safe:
>
>update all_tables set next_extent = 100000000, pct_increase=0
> where next_extent > 100000000 and pct_increase > 0;
>
>--
>greg
Received on Tue Feb 01 2000 - 13:18:32 CST