Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

revoke delete on sys.def$_temp$lob, sys.ol$hints and ol$nodes

yakub21Nov 8 2012 — edited Nov 8 2012
When I do a revoke delete on def$temp$lob from public;
revoke delete on DEF$_TEMP$LOB from public ora-942 table or view does not exist, however the table does exist. Please advise. Thanks

I'm having the same issue with SYS.OL$HINTS and OL$NODES.

Comments

Nigel Deakin-Oracle
The JMS specification doesn't offer a way to explicitly purge a destination (delete all its messages), though your chosen JMS provider might off a non-standard way of doing this.

You could of course simply consume all the messages in a loop.

If you want to use message expiration, don't try using setJMSExpiration on the Message. That method is not for the purpose you might think (see the javadocs). Instead use one of the following methods on MessageProducer:

void setTimeToLive(long timeToLive)
Sets the default length of time in milliseconds from its dispatch time that a produced message should be retained by the message system.

void send(Destination destination, Message message, int deliveryMode, int priority, long timeToLive)
Sends a message to a destination for an unidentified message producer, specifying delivery mode, priority and time to live.

timeToLive is in milliseconds.

Nigel
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2012
Added on Nov 8 2012
#database-security, #database-security-general
1 comment
341 views