CREATE TABLESPACE streams_tbs DATAFILE '/data/oradata/dev/streams_tbs.dbf' 
	SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

REATE USER strmadmin IDENTIFIED BY strmadminpw
	DEFAULT TABLESPACE streams_tbs
   	QUOTA UNLIMITED ON streams_tbs;

GRANT DBA TO strmadmin;

BEGIN
   DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(
     grantee          => 'strmadmin',    
     grant_privileges => true);
   END;
  /
  
  Error while this statement..
  ERROR at line 1:
  ORA-04063: package body "SYS.DBMS_STREAMS_AUTH" has errors
  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STREAMS_AUTH"
  ORA-06512: at line 2

  [B]For that we execute package utlrep.sql and catrep.sql package.[/B]  
  SQL>@c:\oracle\ora92\rdbms\admin\catrep.sql
  
  SQL>@c:\oracle\ora92\rdbms\admin\utlrp.sql
  
[B]problem not solved yet.[/B]

CREATE TABLESPACE streams_tbs_d DATAFILE '/data/oradata/dev/streams_tbs_d.dbf' 
  SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

CREATE USER strmadmin_d IDENTIFIED BY strmadminpw
    DEFAULT TABLESPACE streams_tbs_d
     QUOTA UNLIMITED ON streams_tbs_d;

GRANT DBA TO strmadmin_d;

EGIN
  DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(
    grantee          => 'strmadmin',    
    grant_privileges => true);
  END;
/


error:

BEGIN
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STREAMS_AUTH" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STREAMS_AUTH"
ORA-06512: at line 2

create directory dir_s  as '/data/rep_dir_s';

create directory dir_d as '/data/rep_dir_d';

BEGIN
DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
schema_names => 'strmadmin_d',
source_directory_object => 'dir_s',
destination_directory_object => 'dir_d',
source_database => 'dev',
destination_database => 'dev',
perform_actions => true,
dump_file_name => 'export_rep.dmp',
capture_queue_table => 'rep_capture_queue_table',
capture_queue_name => 'rep_capture_queue',
capture_queue_user => NULL,
apply_queue_table => 'rep_dest_queue_table',
apply_queue_name => 'rep_dest_queue',
apply_queue_user => NULL,
capture_name => 'capture_rep',
propagation_name => 'prop_rep',
apply_name => 'apply_rep',
log_file => 'export_rep.clg',
bi_directional => false,
include_ddl => true,
instantiation => DBMS_STREAMS_ADM.INSTANTIATION_SCHEMA);
END;
/

error: 

BEGIN
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STREAMS_ADM" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STREAMS_ADM"
ORA-06512: at line 2

Elapsed: 00:00:02.00
BEGIN dbms_registry.validate_components; END;

                    *
ERROR at line 1:
ORA-06550: line 1, column 21:
PLS-00302: component 'VALIDATE_COMPONENTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

  1* alter package DBMS_STREAMS_AUTH compile body
11:07:13 SQL> /

Warning: Package Body altered with compilation errors.

Elapsed: 00:00:00.00
11:07:14 SQL> show error
Errors for PACKAGE BODY DBMS_STREAMS_AUTH:

LINE/COL|ERROR
--------|-----------------------------------------------------------------
1178/5  |PL/SQL: Statement ignored
1179/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
1228/5  |PL/SQL: Statement ignored
1229/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
1269/5  |PL/SQL: Statement ignored
1270/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
1286/5  |PL/SQL: Statement ignored
1287/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
11:07:18 SQL> 


-------------------------------------------------


  1* alter package DBMS_STREAMS_ADM compile body
11:09:05 SQL> /

Warning: Package Body altered with compilation errors.

Elapsed: 00:00:00.02
11:09:06 SQL> show error
Errors for PACKAGE BODY DBMS_STREAMS_ADM:

LINE/COL|ERROR
--------|-----------------------------------------------------------------
39/5    |PL/SQL: Statement ignored
40/24   |PLS-00302: component 'DB_COMPATIBLE100' must be declared
147/5   |PL/SQL: Statement ignored
148/24  |PLS-00302: component 'DB_COMPATIBLE100' must be declared
1994/5  |PL/SQL: Statement ignored
1995/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
2198/5  |PL/SQL: Statement ignored
2199/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
2266/5  |PL/SQL: Statement ignored
2267/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
2316/5  |PL/SQL: Statement ignored

LINE/COL|ERROR
--------|-----------------------------------------------------------------
2317/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
2372/5  |PL/SQL: Statement ignored
2373/24 |PLS-00302: component 'DB_COMPATIBLE100' must be declared
11:09:10 SQL> 

SQL> select parameter,value from v$option where parameter like '%Streams%';

Select * from v$version;

19:05:55 SQL> select parameter,value from v$option where parameter like '%Streams%';

PARAMETER                                                       |VALUE
----------------------------------------------------------------|-----------------------------------
Streams Capture                                                 |TRUE

Elapsed: 00:00:00.00
19:05:56 SQL> Select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

Elapsed: 00:00:00.00
19:06:02 SQL>