Re: help

Alden Huen wrote:

> How do you give a user the ability to use sql loader and to analyze tables?
>
> thanks

[Quoted] To use SQL*Loader you must give them access to the bin directory at ORACLE_HOME [Quoted] on the server. Something that should never be done. Consider alternatives.

To analyze a table requires knowing what version you have which, to quote so [Quoted] many, of course wasn't posted. Since you didn't volunteer the information I [Quoted] will assume 8i or 9i in which case you should use the built-in DBMS_STATS package.

Information on this package can be found at http://tahiti.oracle.com

Analyze table, analyze schema etc are there for backward compatibility and [Quoted] should not be used.

Daniel Morgan Received on Sat Feb 08 2003 - 02:04:45 CET