gohar

Saturday, 1 June 2013

Retrieve the table space name for specific user or table

use this syntax to retrive the data about oracle table or user or even by owner.
select *
FROM ALL_TABLES;

Posted by https://ansgohar.blogspot.com/ at 06:01
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Database, Oracle, Schema, SQL, Table Space, User

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2013 (38)
    • ►  September (1)
    • ►  August (12)
    • ►  July (2)
    • ▼  June (6)
      • Naming and Coding Conventions for SQL and PL/SQL
      • ORACLE - UNIQUE Constraints and NULL Values
      • Error: ORA-01033 ORACLE initialization or shutdown...
      • kill specific connection on Oracle Database
      • How to list active / open connections in Oracle
      • Retrieve the table space name for specific user or...
    • ►  May (16)
    • ►  March (1)

About Me

https://ansgohar.blogspot.com/
View my complete profile
Simple theme. Powered by Blogger.