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
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you communicate with operating system files from oracle?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What happens on checkpoint? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is fill factor? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the difference between clustered and non-clustered index? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
How would you go about verifying the network name that the local_listener is currently using?
who owns the operating system files created by the utl_file package?