New Streams Features in 10G

• A new procedure, remove_queue, has been added to the dbms_streams_adm package. This procedure enables the DBA to remove a SYS.AnyData queue. This procedure also has a cascade parameter. When cascade is set to TRUE, any Stream client that uses the queue is also removed.
   /li>

• The dbms_streams_tablespace_adm package provides administrative procedures for copying tablespaces between databases and for moving tablespaces from one database to another. This package uses transportable tablespaces, Data Pump, and the dbms_file_transfer package.
   

• A package called dbms_streams_auth was introduced. It provides procedures that make it easy to configure the Streams administrator.
   

• remove_streams_configuration is a procedure added to the dbms_streams_adm package. This procedure permits the removal of the entire Streams configuration from a database, when required.
   

• New options such as the FOREIGN KEY columns and the ALL columns have been added to the database supplemental logging.
   

• In addition to original export/import, Data Pump export/import, transportable tablespaces, and RMAN can be used to perform Streams instantiations.
   

• A new recursive parameter in the set_schema_instantiation_scn procedure and the set_global_instantiation_scn procedure permits the setting of the instantiation scn for a schema or database, respectively; and for all of the database objects in the schema or database.