Oracle Database Discussions

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!

Oracle Streams spaced increase in sysaux v streams_tbs tablespace

592815Feb 23 2009 — edited Mar 6 2009

Hi Experts,

I created a stream for oracle10GR4 in 32 bit window.
I created and granted strasmin for operating stream as
connect SYS/password as SYSDBA
I created a separated a streams_tbs tablespace to support stream.
create user STRMADMIN identified by absol
default tablespace streams_tbs
temporary tablespace temp

However, I saw that tablespace streams_tbs does not used data in there. But I saw Oracle Streams spaced uased is increased in sysaux tablespace

Why? How to fix this issue?
As you know sysaux tablespace have a space limitted and performace issue. I like to put data into separated tablespace to support data replication.

Thanks for help
Jim

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2009

Added on Feb 23 2009

#general-database-discussions

5 comments

887 views