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!

Tablespaces used in user schema

423371Dec 5 2006 — edited Dec 5 2006

guys,

I want to find all tablespaces used in user schema - scott. I tried using views like v$tablespace, v$datafile.. but doesnt seem to help.

any suggestions/inputs ??

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2007

Added on Dec 5 2006

#general-database-discussions

8 comments

719 views