What view would you use to determine free space in a tablespace?
Answer Posted / 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 |
Post New Answer View All Answers
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can you communicate with operating system files from oracle?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you initialize log miner?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you record information about current session?
internal architecture
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Explain materialized views and how they are used.
how can you find out if a table can be redefined?
what is logical system in sap basis