Answer Posted / guest
dbcc dbreindex ('table_name' [, index_name [,
fillfactor ]]) [WITH NO_INFOMSGS]
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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 to start SQL Server in minimal configuration mode?
What the different topologies in which replication can be configured? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
which background process invoke at the time of upgradation tell me???
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what are the types of connection load-balancing?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
how can you create a user-defined lock?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What authentication modes does sql server support? : 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.