What view would you use to determine free space in a tablespace?
Answers were Sorted based on User's Feedback
Answer / guest
It is dba_free_space which gives u the info about free
space in any tablespace
Regards
Abhinav
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / rajesh naidu
SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FROM
DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;
AND THE VIEW IS DESC DBA_FREE_SPACE;
Is This Answer Correct ? | 2 Yes | 2 No |
by issuing "alter tablespace begin backup;" what happens to tablespace?
i had backup last manday.now i need back monday to now ..how do get backup?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How can you rebuild an index?
What are the operating modes in which database mirroring runs? : sql server DBA
What command would you use to create a backup control file?
How can you enable a trace for a session?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is ora 600?
What's the benefit of "dbms_stats" over "analyze"?
Which autogrowth database setting is good? : sql server DBA