Re: Admin Tasks Re-indexing

Edmonton,

From your question its not very clear about the problem you are facing about index. The index information is auotmatically updated for the new rows that are inserted. If you have any problems with the index you can drop the index by using 'DROP INDEX' & again recreate the with 'CREATE INDEX' but if the table is a large table it will consume lot of time.

For ADMIN utilities there are a nos. of SQLDBA commands which you can find in the adminstrator's manual also there are utilites which are provided by ORACLE Corp. like EXP - for exporting the tablespace, IMP - for importing data.

Will this help you,

Ravi : ravibn_at_hotmail.com

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.