Khamis, 6 November 2014

how to find the tablespace of a schema in oracle


 select * from DBA_TABLES

select owner,table_name,tablespace_name,tablespace_name from DBA_TABLES

select owner,table_name,tablespace_name from DBA_TABLES
where table_name = 'MTL_SYSTEM_ITEMS_B';

Tiada ulasan:

Catat Ulasan