Exadata General (MOSC)

MOSC Banner

How to list DBFS tablespaces

edited Jan 11, 2015 10:00AM in Exadata General (MOSC) 1 commentAnswered

Hello,

   1) From database, how can we list all tablespaces which are DBFS (in despite their associated dbfs filesystem is umount) ?

   2) From database, how can we list the "DBFS" tablespaces associated to a  "store_mount" ( or to a "dbfs user")

       Because, when we execute this command :

               @dbfs_create_filesystem.sql <tablespace_name> <FS_name=store_mount>

       We searched hard to found where oracle store the tablespace associated to "store_mount" or to "dbfs user".

Thank you in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center