Thursday, 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';

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete