hint explicitly notifies the optimizer to not to use the specified index(s).
This can be used for query testing purpose without dropping the actual index. In
some cases queries will give better performance without indexes. This
difference can be tested using this hint. This hint applies to function_based,
B-tree, bitmap, cluster indexes.
You have to create a
procedure with truncate table command (dynamic SQL) and grant the execute procedure
privilege to the other user. This method will help you to avoid the granting of
drop any table privilege to the
target user. Here is the example for the same.
I have 2 users
called test and sthomas. Test wanted to drop the table from the sthomas schema.
Dept table has 4 records.
a.Query to check AWR
snapshot interval and retention period set for the database. In below example
the snapshot interval is one hour and retention is 8 days. The data type for
the columns SNAP_INTERVAL RETENTION is having two fields – days and time with hour, min,