Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
If we find that fragmentation of space in a tablespace is
high (contiguous space on our disk appears as
non-contiguous),we can coalesce any free space using the
ALTER TABLESPACE TABLESPACE_NAME COALESCE ; command
We must have the ALTER TABLESPACE system privilege to
coalesce tablespaces.
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What purpose does the model database server? : sql server DBA
what is grd?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is a correlated sub-query? : sql server DBA
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 would you best determine why your MVIEW couldn't FAST REFRESH?
Which autogrowth database setting is good? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
who owns the operating system files created by the utl_file package?
what is the use of ocr?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
