Well, first of all I would suggest Golden Gate instead of Streams.
They are similar but Oracle is emphasizing Golden Gate and that is what will be getting maintained in the future.
I do not think Streams is going to be updated in the future.
Streams should replicate the objects you mention but there are certain datatypes it will not stream. They are listed in the reference manual and might not be an issue. Last time I looked at Golden Gate they also would not stream certain data types.. Most of the usual types do stream.
Avraam Jack Dectis
Thanks Avraam. Can you point me to documentation where it says that stored procedure and database code will be copied? I am getting conflicting answers for what should be a simple answer.
Again, in my understanding "data types" would refer to columns in the table. In the Oracle documentation link below it talks about table and materialized views not the database stored procedures and other database object.
take care: you referenced advanced replication docs with your link.
You can replicate DDL with streams. See here
You should create schema or database level rules for the streams capture with include_ddl set to true, then all PL/SQL objects are captured, add LCRs with the DDL are created.
You can use Schema Level replication using Oracle Stremas or Oracle GoldenGate to replicate DDL's like Procedure/trigger/package etc. for that user.