Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

        
 

 Oracle Alter Subscriber
Oracle Tips by Burleson Consulting

Advanced Oracle Utilities: The Definitive Reference by Rampant TechPress is written by four of the top Oracle database experts (Bert Scalzo, Donald Burleson, and Steve Callan).  The following is an excerpt from the book.

Alter_subscriber is a procedure that modifies a queue subscriber’s properties. The rule parameter is a conditional expression string much like a WHERE clause, and must be properly (double) quoted. Note that this procedure permits altering both the rule and the transformation. If one wants to retain the existing value for either of them, specify the old value.

 

Argument

Type

In / Out

Default Value

QUEUE_TABLE

VARCHAR2

IN

 

SUBSCRIBER

SYS.AQ$_AGENT

IN

 

RULE

VARCHAR2

IN

 

TRANSFORMATION

VARCHAR2

IN

 

Table 6.65:  Alter_subscriber Parameters

Create_aq_agent is a procedure that creates an AQ agent’s registration for internet access. However, for access through HTTP, the certificate location is not required.

 

Argument

Type

In / Out

Default Value

AGENT_NAME

VARCHAR2

IN

 

CERTIFICATE_LOCATION

VARCHAR2

IN

NULL

ENABLE_HTTP

BOOLEAN

IN

FALSE

ENABLE_SMTP

BOOLEAN

IN

FALSE

ENABLE_ANYP

BOOELAN

IN

FALSE

Table 6.66:  Create_aq_agent Parameters

Create_np_queue is a procedure that creates a non-persistent RAW queue which has been deprecated as of Oracle 10gR2, so use buffered messaging instead.

 

Argument

Type

In / Out

Default Value

QUEUE

VARCHAR2

IN

 

MULTIPLE_CONSUMERS

BOOLEAN

IN

FALSE

COMMENT

VARCHAR2

IN

NULL

Table 6.67:  Create_np_queue Parameters

Create_queue is a procedure that creates a message queue within the specified queue table. Note that a message is automatically transferred to an exception queue if retry_count >max_retries. Retry count. Also note that the auto_commit parameter has been deprecated.

 

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

QUEUE_TABLE

VARCHAR2

IN

 

QUEUE_TYPE

BINARY_INTEGER

IN

NORMAL_QUEUE

MAX_RETRIES

NUMBER

IN

NULL

RETRY_DELAY

NUMBER

IN

0

RETENTION_TIME

NUMBER

IN

0

DEPENDENCY_TRACKING

BOOLEAN

IN

FALSE

COMMENT

VARCHAR2

IN

NULL

AUTO_COMMIT

BOOLEAN

IN

TRUE

Table 6.68:  Create_queue Parameters

Create_queue_table is a procedure that creates a queue table of a predefined message type. The storage_clause parameter takes the same text as in a standard CREATE TABLE storage clause. The primary instance performs the monitor scheduling and propagation for the queues in the queue table. The secondary instance is strictly for failover, as when the primary instance is unavailable. Also note that the auto_commit parameter has been deprecated.

 

Argument

Type

In / Out

Default Value

QUEUE_TABLE

VARCHAR2

IN

 

QUEUE_PAYLOAD_TYPE

VARCHAR2

IN

 

STORAGE_CLAUSE

VARCHAR2

IN

NULL

SORT_LIST

VARCHAR2

IN

NULL

MULTIPLE_CONSUMERS

BOOLEAN

IN

FALSE

MESSAGE_LOGGING

BINARY_INTEGER

IN

NONE

COMMENT

VARCHAR2

IN

NULL

AUTO_COMMIT

BOOLEAN

IN

TRUE

PRIMARY_INSTANCE

BINARY_INTEGER

IN

0

SECONDARY_INSTANCE

BINARY_INTEGER

IN

0

COMPATTIBLE

VARCHAR2

IN

NULL

SECURE

BOOLEAN

IN

FALSE

Table 6.69:  Create_queue_table Parameters

Del_alias_from_ldap is a procedure that drops an alias for an object, i.e. queue, agent or connection factory.

 

Argument

Type

In / Out

Default Value

ALIAS

VARCHAR2

IN

 

Table 6.70:  Del_alias_from_ldap Parameters

Disable_db_access is a procedure that revokes AQ Internet agent privileges from a specified database user.

 

Argument

Type

In / Out

Default Value

AGENT_NAME

VARCHAR2

IN

 

DB_USERNAME

VARCHAR2

IN

 

Table 6.71:  Disable_db_access Parameters

Disable_propagation_schedule is a procedure that disables a propagation schedule. If the destination parameter for the destination database link is NULL, then the destination is the local database and all messages are propagated to other local database queues.

 

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

DESTINATION

VARCHAR2

IN

NULL

DESTINATION_QUEUE

VARCHAR2

IN

NULL

Table 6.72:  Disable_propagation_schedule Parameters

Drop_aq_agent is a procedure that drops an AQ agent’s registration for internet access.

Argument

Type

In / Out

Default Value

AGENT_NAME

VARCHAR2

IN

 

 

Table 6.73:  Drop_aq_agent Parameter

Drop_queue is a procedure that drops a message queue. Note that the auto_commit parameter has been deprecated. Also remember to first call stop_queue.

 

Argument

Type

In / Out

Default Value

QUEUE_NAME

VARCHAR2

IN

 

AUTO_COMMIT

BOOLEAN

IN

TRUE

Table 6.74:  Drop_queue Parameters

Drop_queue_table is a procedure that drops a queue table. The force parameter controls whether a queue table containing queues can be dropped. Note that the auto_commit parameter has been deprecated.

 

Argument

Type

In / Out

Default Value

QUEUE_TABLE

VARCHAR2

IN

 

FORCE

BOOLEAN

IN

FALSE

AUTO_COMMIT

BOOLEAN

IN

TRUE

Table 6.75:  Drop_queue_table Parameters


     

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.