oracle concepts for you
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';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment