Query to identify a table size in Oracle
SELECT segment_name,segment_type,bytes/1024/1024 MB
FROM dba_segments
WHERE segment_type='TABLE' AND segment_name='PS_BI_EXTRCT_LINE';
Saturday, May 24, 2014
Subscribe to:
Post Comments (Atom)
Reference codes used in PeopleSoft Projects
No comments:
Post a Comment