查看表空间

select * from user_tablespaces where table_name = 'TableName'

查看表属主

select  Owner  from all_tab_columns where table_name = 'TableName'

 

附录：

A tablespace is a storage location where the actual data underlying  objects can be kept. It provides a layer of abstraction between physical and logical data, and serves to allocate storage for all  managed segments. (A database segment is a database object which occupies physical space such as data and .) Once created, a tablespace can be referred to by name when creating database segments.

Tablespaces specify only the database storage locations, not the logical database structure, or . For instance, different objects in the same schema may have different underlying tablespaces. Similarly, a tablespace may service segments for more than one schema. Sometimes it can be used to specify schema as to form a bond between logical and physical data.

By using tablespaces, an administrator can control the disk layout of an installation. A common use of tablespaces is to optimize performance. For example, a heavily used index can be placed on a fast  . On the other hand, a database table which contains archived data that is rarely accessed could be stored on a less expensive but slower  disk.

While it is common for tablespaces to store their data in a filesystem file, a single file must be part of a single tablespace. Some allow tablespaces to be configured directly over operating-system device entries, called , providing better performance by avoiding the OS filesystem overheads.

 stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace.

reference：http://en.wikipedia.org/wiki/Tablespace