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!

Segment Advisor for schema

Gowin_dbaSep 18 2012 — edited Sep 18 2012

Hi,

How to run Segment Advisor report manually for specific schema, which owing objects in 30 tablespaces.
Looking for report in single shot rather than creating dbms_advisor.create_object(name, 'TABLESPACE',....) for 30 tablespaces and getting action message from dba_advisor_actions for all 30 tasks.

Version : 11.2
OS : SunOS
OEM : N/A
Automatic Segment Advisor : N/A

Thx,
Gowin.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2012

Added on Sep 18 2012

#general-database-discussions

3 comments

423 views